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