Ctrl F1 , hide ribbons in Excel
How can I write a VBA to do the same at File Opening ?
Ctrl F1 , hide ribbons in Excel
How can I write a VBA to do the same at File Opening ?
How aboutPlease Login or Register to view this content.
Ok, so were I should put this, so when I Open the file, Ribbon will go away ?
Put it in the Workbook open event.
This looks like is Crtl Shitft F1
Can I have Crtl F1 only ?Please Login or Register to view this content.
How aboutPlease Login or Register to view this content.
It say Object variable with block variable not set
What is your entire code?
I like the answer #5 but could you please create a button
- if I press once I get ...false (post #5 code)
- if i press one more time I get it back ....true
You asked for something that would work when you opened the file, not a toggle button.
Yes, but then I realized that with Ctrl Shift F1 , I can not even save the file, all the ribbons are gone !
You don't need any more code, the post#5 is all you need.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks