Hide menu bar or command bars in Excdel 2007 and higher

[nagovind]

Hi All


Similar to the below commands in Excel 2003 please share the VBA code to hide .."Advance" menu item under FILE menu and to hide "Review" menu in Excel 2007 and higher....hide or make it disable...


Application.CommandBars("Worksheet Menu Bar").Controls("tools").Enabled = False

Application.CommandBars("Worksheet Menu Bar").Controls("file").Enabled = True

Application.CommandBars("Worksheet Menu Bar").Controls("insert").Enabled = False


Please share the code

 

[prasaddn]

Hi Nagovind...


pls check my response in below topic..


http://chandoo.org/forums/topic/excel-full-screen-border-less-display


It works with 2007 and higher version as well.


Regards,

Prasad