Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost Menu Bar
Hi to everybody,
Using Excel XP, the menu bar has disappeared and will not return. I have reset the toolbars to no avail. I have also 'repaired' Excel to no avail. I understand that I need to use customise toolbars to re-enable the Worksheet menu bar, however it is not there, neither is the chart menu selection! I have searched the machine for my .xlb file as I understand that deleting that file will cause Excel to recreate a new file with the standards settings. In the absence of any .xlb file and no menu's, can anyone suggest a way forward please? I am loathe to reinstall Excel as that ends up messing Outlook and other programs up as well. Cheers, Mickey |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost Menu Bar
Hi again,
Just for info of any others who get this problem. I finally found the file but it was named Excel10, least I think this is it. I deleted Excel10 (heart stopping moment) and my menus returned! No sign it was the .xlb file but the search for *.xlb found nothing else other than this file. Mickey |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost Menu Bar
Mickey
You have....... Right-clicked on any Toolbar and CustomizeToolbars but found no Worksheet Menu Bar to reset? Nor any Chart Toolbar? Searched your Computer for *.XLB with settings to unhide all extensions and search hidden files also? I find it difficult to believe that you have used Excel without generating an *.XLB file. Another option....... Hit ALT + F11 to open visual basic editor. ViewImmediate Window. Copy and paste this line in then hit ENTER. Application.CommandBars(1).Reset ALT + F11 to go back to Excel to see if Worksheet Menu Bar visible. Gord Dibben XL2002 On Mon, 8 Dec 2003 00:48:34 -0000, "Mickey" wrote: Hi to everybody, Using Excel XP, the menu bar has disappeared and will not return. I have reset the toolbars to no avail. I have also 'repaired' Excel to no avail. I understand that I need to use customise toolbars to re-enable the Worksheet menu bar, however it is not there, neither is the chart menu selection! I have searched the machine for my .xlb file as I understand that deleting that file will cause Excel to recreate a new file with the standards settings. In the absence of any .xlb file and no menu's, can anyone suggest a way forward please? I am loathe to reinstall Excel as that ends up messing Outlook and other programs up as well. Cheers, Mickey |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost Menu Bar
Good deal.
If your Windows ToolsFolder OptionsView settings are set to "hide known file extensions" you won't see the extensions(as you found out). Excel10.xlb is the correct file. Gord Dibben XL2002 On Mon, 8 Dec 2003 01:10:28 -0000, "Mickey" wrote: Hi again, Just for info of any others who get this problem. I finally found the file but it was named Excel10, least I think this is it. I deleted Excel10 (heart stopping moment) and my menus returned! No sign it was the .xlb file but the search for *.xlb found nothing else other than this file. Mickey |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lost Menu Bar
Thanks Gord, all well now,
Mickey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Lost Menu heading | Excel Discussion (Misc queries) | |||
HELP!!!! Lost Menu Bar!!!! Please Help (sob) | Setting up and Configuration of Excel | |||
Lost my "Menu Bar" | Excel Discussion (Misc queries) | |||
Lost my menu bar commands | Excel Discussion (Misc queries) | |||
How to get back lost Menu | Excel Programming |