Hi,
I would like to hide certain Excel menu items on a specific spreadsheet.
I tried the following code to hide the "File" menu item for example.
Sub toto()
Application.CommandBars("Worksheet Menu Bar").FindControl (ID:=30002).Enabled = False
End Sub
It works fine. I then have to use "Enabled = True" to reset it as it is supposed to be.
I found a major limitation. If excel bombs, for whatever reason, the next time Excel is openend, the "File" menu item will not be available (since the "Enabled = True" will not have been executed).
Is there another way to hide a menu item, that would only affect the current file?
Thanks
Bookmarks