Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rebuild XL Worksheet Menu Bar
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Rebuild XL Worksheet Menu Bar
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Is there a way to unload the loaded XLL file in Excel? Hi all, I amdebugging XLL link library using Visual C++. Everytime I rebuild the XLL, Ihave to close the whole Excel program and relaunch the Excel program again,and then load in the newly gene | Excel Discussion (Misc queries) | |||
Can I create a worksheet menu to select each other worksheet | Excel Discussion (Misc queries) | |||
Worksheet menu bar | Excel Discussion (Misc queries) | |||
Need to rebuild formula using the value entered into a cell on the | Excel Worksheet Functions | |||
worksheet menu bar | Excel Discussion (Misc queries) |