Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel worksheet Menu Toolbar
I lost my Menu Toolbar and can't find it. The Standard & Formatting
toolbars with icons are still at top of worksheet. I can use the Alt = F, E etc to get some items to open but need the Menu items back. It is "checked" in the toolbars listing but it does nothing to "uncheck" it either. Suggestions please. -- Mickey |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel worksheet Menu Toolbar
In VBE immediate window (Alt-F11 then Ctrl-g), type:
commandbars("worksheet menu bar").Reset That should help -- AP "Mikey" a écrit dans le message de news: ... I lost my Menu Toolbar and can't find it. The Standard & Formatting toolbars with icons are still at top of worksheet. I can use the Alt = F, E etc to get some items to open but need the Menu items back. It is "checked" in the toolbars listing but it does nothing to "uncheck" it either. Suggestions please. -- Mickey |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel worksheet Menu Toolbar
No help. I can access the Tools Customize function by right clicking on the
blank menu bar at top. It has all the various toolbars listed and the Worksheet Menu bar IS checked but doesn't show up above the Icon buttons. Other suggestions? I can't function without it. -- Mickey "Ardus Petus" wrote: In VBE immediate window (Alt-F11 then Ctrl-g), type: commandbars("worksheet menu bar").Reset That should help -- AP "Mikey" a écrit dans le message de news: ... I lost my Menu Toolbar and can't find it. The Standard & Formatting toolbars with icons are still at top of worksheet. I can use the Alt = F, E etc to get some items to open but need the Menu items back. It is "checked" in the toolbars listing but it does nothing to "uncheck" it either. Suggestions please. -- Mickey |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel worksheet Menu Toolbar
That did it! Thanks a bunch. How did it happen though? And the one that
was displayed wasn't modified with the additional items I added to it such as "page setup" and the "freeze panes" icon. I looked for *.xlb files which some help site said contained the modified toolbar configuration but didn't find anything. Other comments welcomed. -- Mickey "Ardus Petus" wrote: Maybe your menu bar is located outside the screen. In Immediate window, try: set cb = commandbars("worksheet menu bar") cb.top=0 cb.left=0 HTH -- AP "Mikey" a écrit dans le message de news: ... No help. I can access the Tools Customize function by right clicking on the blank menu bar at top. It has all the various toolbars listed and the Worksheet Menu bar IS checked but doesn't show up above the Icon buttons. Other suggestions? I can't function without it. -- Mickey "Ardus Petus" wrote: In VBE immediate window (Alt-F11 then Ctrl-g), type: commandbars("worksheet menu bar").Reset That should help -- AP "Mikey" a écrit dans le message de news: ... I lost my Menu Toolbar and can't find it. The Standard & Formatting toolbars with icons are still at top of worksheet. I can use the Alt = F, E etc to get some items to open but need the Menu items back. It is "checked" in the toolbars listing but it does nothing to "uncheck" it either. Suggestions please. -- Mickey |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Excel worksheet Menu Toolbar
Glad I could help!
Cheers, -- AP "Mikey" a écrit dans le message de news: ... That did it! Thanks a bunch. How did it happen though? And the one that was displayed wasn't modified with the additional items I added to it such as "page setup" and the "freeze panes" icon. I looked for *.xlb files which some help site said contained the modified toolbar configuration but didn't find anything. Other comments welcomed. -- Mickey "Ardus Petus" wrote: Maybe your menu bar is located outside the screen. In Immediate window, try: set cb = commandbars("worksheet menu bar") cb.top=0 cb.left=0 HTH -- AP "Mikey" a écrit dans le message de news: ... No help. I can access the Tools Customize function by right clicking on the blank menu bar at top. It has all the various toolbars listed and the Worksheet Menu bar IS checked but doesn't show up above the Icon buttons. Other suggestions? I can't function without it. -- Mickey "Ardus Petus" wrote: In VBE immediate window (Alt-F11 then Ctrl-g), type: commandbars("worksheet menu bar").Reset That should help -- AP "Mikey" a écrit dans le message de news: ... I lost my Menu Toolbar and can't find it. The Standard & Formatting toolbars with icons are still at top of worksheet. I can use the Alt = F, E etc to get some items to open but need the Menu items back. It is "checked" in the toolbars listing but it does nothing to "uncheck" it either. Suggestions please. -- Mickey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
unhide menu bar in excel - just disappeared | Setting up and Configuration of Excel | |||
Customizing Worksheet Menu Bar for a workbook without VBA coding | Excel Discussion (Misc queries) | |||
Sharing worksheet with a customer toolbar | Excel Worksheet Functions | |||
create menus in excel worksheet | Excel Worksheet Functions |