Unhide Worksheet menu bar

[Praxey]

Hello friends,

I know that many people would be thinking of unhiding Worksheet from menu bar for that you have to create a macro where it will hide your menu bar from your worksheet and at the same time i had seen that many people don't want toolbar whenever they are working in Excel so friends here is the macro for it

Sub hidemenubar()
CommandBars("Worksheet Menu Bar").Enabled = False
End Sub

[Kane01]

Thank you for posting such kind of tips i was finding if from a long back it would be great if you can tell me how can i create a macro because i am new to Excel VBA and don't have any idea about it. Can anyone tell me or direct me on how to create macro in Excel. Your small suggestion would be very helpful for me.

[Bud]

For creating a macro you need to first go to VBA for that you need to press Alt + F11 and after that you need to press (Ctrl + G) for getting immediate window, then copy paste the code in window and you had done for the same. If you want to learn in more details then you can check otu below links for more information

How to create a macro in Excel
Record a Macro in MS Excel
Procedure to create Auto-Run Macro

[Dr.pter]

If you don't want to use any code then for that you can also do it by selecting add/remove buttons and over there you will find customize button and then select on format, hide, option and after that after that close your application and start it once again, i am sure after that you will not see menu bar whenever you open your worksheet.