Thanks. But in this instance the macro security setting is set to "High" (an
installation default, sorry to say), which means that VBA code can't run.
Since the Worksheet Menu Bar is missing, there's no way to set macro security
to "Medium" or "Low." Some sources recommend deleting any XLB files and
re-starting. I'll try this when next I have access to the user's computer.
Any comment?
--
Rick Solie


"Gord Dibben" wrote:

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?