Hi there!
I am struggling with an issue I cannot find an answer for on this forum nor Google.
I would like my Excel file to hide the ribbon bar on only one sheet when I open my workbook. Is this even possible? Or is it only possible to do so for the whole workbook?
Many thanks in advance for your help!
Regards,
Thomas
Like this?
Please Login or Register to view this content.
Make Mom proud: Add to my reputation if I helped out!
Make the Moderators happy: Mark the Thread as Solved if your question was answered!
Works great, daffodil11! Thanks a lot!
As I wanted to have no headings or formula bar on this sheet, I changed the code to this:
It seems to work, but just wanted to check whether this is the best way to goPlease Login or Register to view this content.
I'd actually edit the Open event to include the exact same code as the Activate.
This way if the workbook is saved and closed on the Talent sheet, when it opens it pops with those same adjustments.
or maybe evenPlease Login or Register to view this content.
Please Login or Register to view this content.
Great! Works like a charm.
Thanks a ton for your help!
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks