Hi everyone, I have produced a excel order for one of our clients but I hate that they can see the Ribbon bar would prefer to see it shown as a full screen no ribbon bar unless I need to work on it, this VBA code needs to work every time the order form is opened. I have tried a lot of code but had no luck with it sticking every time it is opened. can anyone help with a simple VBA code, or have a better solution for to get the result I want.
Using this syntax in ThisWorkBook:
Use ALT / F11 to get to the VBEditor. From there you can comment out the
Please Login or Register to view this content.
two commands in ThisWorkbook, save the workbook, then close it.
When you reopen the workbook the menu will be available again allowing you to
work on the contents.
Last edited by Logit; 11-30-2016 at 12:28 AM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks