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.
--
Rick Solie

Alt - T - C

Rick Solie wrote:

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.

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?
--
Rick Solie


"Bob I" wrote:

Alt - T - C

Rick Solie wrote:

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.

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

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?

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?

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?