Vba Hide Worksheet Menu Bar. All I want to do is hide the menu bar when the user clicks the 'optimise view' button and reset everything back to normal when the 'close game' button is clicked. If your template design requires making Excel look less like Excel, you might want to turn off sheet tabs.
This module will be shown in the Project Explorer. All I want to do is hide the menu bar when the user clicks the 'optimise view' button and reset everything back to normal when the 'close game' button is clicked. This is all being done from a module in the Excel VBA project.
Use VBA to Unhide All the Hidden Sheets.
The only way the 'menu bar' or 'Ribbon' itself can be hidden is through VBA.
Step by step Excel VBA is a Microsoft programming language for Excel VBA. So we would like it too look the least like an excel program as possible. I used this in a packing list program to stop inexperienced users from making changes.