I have the following code in vba, but with this I make all ribbons invisible.
Now I want that only the ribbon of the relevant sheet is invisible. and if I open another sheet that the ribbon is visible there.
Private Sub Workbook_Open()
Application.ExecuteExcel4Macro "SHOW.TOOLBAR(""Ribbon"",False)"
End Sub
The place the code in the worksheet module and not in the workbook module
WorkSheet_Activate
---
Hans
"IT" Always crosses your path!
May the (vba) code be with you... if it isn't; start debugging!
If you like my answer, Click the * below to say thank-you
thanks for the reply, but that is not working. nothing happens.
Can you explain what DOES happen?
You'll probably have to add a check if already minimized to maximize and vv
Try this file and select the other sheet and then back to the first one
i copied the codes in my sheets and it doesnt work, very strange
What did you copy and what did you do?
Moet gewoon werken.
ik heb de codes in allebei de sheets gekopieerd en in mijn sheets gezet. daarna opgeslagen en geopend en er gebeurd niks
For this section we continue in English.
Check the code lines and see what they do:
One sets it True (minimized) and the other sets it False.
You will have to play around with it.
Else attach a sample book and explain what you want with which sheet.
I musr say that hiding and showing the ribbon gives a very unpleasant effect, but that's your decision and choice.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks