Alt + F11 to go to VBE.

CTRL + r to open Project Explorer.

Select your workbook/project and InsertModule

Paste this in and run it.

Sub Worksheet_Menu_Toggle()
If Application.CommandBars("Worksheet Menu Bar").Enabled = True Then
Application.CommandBars("Worksheet Menu Bar").Enabled = False
Else
Application.CommandBars("Worksheet Menu Bar").Enabled = True
End If
End Sub


Gord Dibben MS Excel MVP

On Thu, 4 Dec 2008 04:33:12 -0800, Rick Solie
wrote:

Thanks for this, but no luck, Alt-T-C did nothing. I think the menu bar is
"disabled" and not just not visible. The checkbox for the worksheet menu bar
doesn't appear on the customization drop-down list either. Any other
suggestions?