Missing worksheet menu bar Excel 2003

[Rick Solie]

From time to time one of my users will close my custom Excel 2003 application
and find the worksheet menu bar (File, Edit, Tools, etc.) missing in regular
Excel.

Customizing the toolbars in the usual way won't work because the worksheet
menu bar is missing from the choices, and In our installation macros are
disabled by default so code won't work either.

I need a way either to restore the menu bar with, say, a keyboard shortcut,
or to enable macros without the menu so VBA code can run. Any help will be
much appreciated.

 

[Bob I]

Alt - T - C

 

[Rick Solie]

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?

 

[Bob I]

Humm, if the macros cripple it, you may be trying to swim upstream.

 

[Gord Dibben]

Alt + F11 to go to VBE.

CTRL + r to open Project Explorer.

Select your workbook/project and Insert>Module

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

 

[Rick Solie]

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?