Rebuild XL Worksheet Menu Bar

H

hglamy

Hello there,

after experimenting with custom sample command bars in XL 2002,
I can't get back to the standard Worksheet Menu Bar at all.

Due to macro security settings = high, vba-code like

Sub Rebuild
Commandbars(1).enabled = True
End Sub

is refused.

De- and subsequent Re-Installation of the Programm still produces
Excel with the unwanted and useless Custom Command Bar, without
the menus / commands that I need.

How can I, under these circumstances, get back to the Worksheet Menu Bar ?

Your help is greatly appreciated !

Kind regards,

H. G. Lamy
 
T

Tom Ogilvy

right click on the empty area of any menu or toolbar and select customize.
select the worksheet menu bar in the first tab and hit reset.

or

close excel
Find your *.xlb file use the search for files in the start menu, then rename
this or delete it (you will lose any existing customizations).

Regards,
Tom Ogilvy
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

menu bar and error 91 3
problem with custom menu 4
List Visible Controls in CommandBars("Worksheet Menu Bar") 3
Error when creating menu item on command bar 2
Declaring Command Bar Control 4
Face id on custom menu bar. 2
Worksheet tab popup menu not working 3
Worksheet menu bar using code???? 4

Top