I have a code that hides the ribbons on top of my excel sheet
and the code looks like this.
If I want to start this function aromatically without assigning the function to a button how do I code and start this function
and the code looks like this.
Code:
Private Sub Workbook_Activate()
Application.ScreenUpdating = False
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
Application.DisplayFormulaBar = False
Application.DisplayStatusBar = Not Application.DisplayStatusBar
ActiveWindow.DisplayWorkbookTabs = False
Application.ScreenUpdating = True
End Sub
Last edited by a moderator: