I was wondering if anyone knows the vba code to hide the ribbon and show only the menu bar? I have tried many different things but still cannot get it to work. Please help!
Respectfully,
J
I was wondering if anyone knows the vba code to hide the ribbon and show only the menu bar? I have tried many different things but still cannot get it to work. Please help!
Respectfully,
J
Hello Acousticlife81,
With VBA Thisworkbook Activate Event, use the following Code;
Regards.Please Login or Register to view this content.
Please consider:
Be polite. Thank those who have helped you. Then Click on the star icon in the lower left part of the contributor's post and add Reputation. Cleaning up when you're done. If you are satisfied with the help you have received, then Please do Mark your thread [SOLVED] .
.
Or were you meaning this :
.
You want this portion to be visible : Home Insert Page Layout Formulas Data Review View Developer
[CODE]
Option Explicit
Private Sub Workbook_Activate()
If Application.CommandBars("Ribbon").Height > 100 Then
SendKeys "^{F1}"
DoEvents
End If
End Sub
Private Sub Workbook_Deactivate()
If Application.CommandBars("Ribbon").Height < 100 Then
SendKeys "^{F1}"
DoEvents
End If
End Sub
[/CODE
Hey Winon ! Good to see you again.
Hello Acousticlife81,
If you prefer you may add Buttons to the relevant Sheet to select what you would like to see, as per the sample attached.
Regards.
@ Logit,
Hi there Buddy!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks