View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
hglamy[_2_] hglamy[_2_] is offline
external usenet poster
 
Posts: 17
Default Rebuild XL Worksheet Menu Bar

Thank you, Tom, that did it ! I'm relieved !

Regards,

H.G. Lamy


"Tom Ogilvy" schrieb im Newsbeitrag
...
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


"hglamy" wrote in message
...
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