Karla Bermeo
New Member
- Joined
- Feb 21, 2020
- Messages
- 3
- Office Version
- 2016
- Platform
- Windows
Hi guys!
First of all I'm so grateful for your help on my first post. I have a new question, so I hope you can help me this time. The case is the following:
I have a macro to hide Excel ribbon options when we open a workbook, but it works only when I have the workbook open, when I close and open again the workbook, the ribbon doesn't hide. I don't know where is the problem. Btw, I also have a form to access to it, just when the person writes the right user and password:
Private Sub workbook_open()
Application.Visible = False
uf_login.Show
With ThisWorkbook.Worksheets
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
Application.DisplayFullScreen = False
End With
End Sub
I want to hide all the toolbars (ribbon options) when a person opens the workbook, and just if it's possible, to show only some customized buttons of the quick access toolbar, as shown in the picture below:
First of all I'm so grateful for your help on my first post. I have a new question, so I hope you can help me this time. The case is the following:
I have a macro to hide Excel ribbon options when we open a workbook, but it works only when I have the workbook open, when I close and open again the workbook, the ribbon doesn't hide. I don't know where is the problem. Btw, I also have a form to access to it, just when the person writes the right user and password:
Private Sub workbook_open()
Application.Visible = False
uf_login.Show
With ThisWorkbook.Worksheets
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
Application.DisplayFullScreen = False
End With
End Sub
I want to hide all the toolbars (ribbon options) when a person opens the workbook, and just if it's possible, to show only some customized buttons of the quick access toolbar, as shown in the picture below:
