View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default Unhide Main Menu Bar

Bob

I find that if Worksheet Menu Bar has been disabled it will not show up in the
CustomizeToolbars dialog so can't be reset.

Application.CommandBars("Worksheet Menu Bar").Enabled = False

needs the following to become enable again

Application.CommandBars("Worksheet Menu Bar").Enabled = True

Any other method?

Gord

On Fri, 2 Feb 2007 10:44:41 -0000, "Bob Phillips" wrote:

You could right-click anywhere in the remaining toolbars, and choose
Customize, select the Toolbars tab, and hit the Reset button.