| Home |
| Search |
| Today's Posts |
|
#9
|
|||
|
|||
Many many thanks...the second option worked!
"Dave Peterson" wrote: It worked fine for me (multiple times). I used this: application.commandbars("worksheet menu bar").Enabled = true and it worked lots of times. ===== Another option is to kill all the toolbars and start over. Close excel windows start button|search| look for *.xlb (remember to look in hidden folders, too!) If you want, rename all you find to *.xlbOLD (just in case). Then restart excel. If it worked ok, delete those *.xlbOLD files. If it didn't work ok, close excel and rename them back to *.xlb (no harm, no foul). Blur wrote: Thanks Dave: I got the message when i hit ENTER after typing in the entire syntax u have provided. I thought i typed wrongly, so i did a COPY and PASTE, hit ENTER and still get the same message. "Dave Peterson" wrote: What point did you get that message? And what did you type into the immediate window? Blur wrote: Thanks Dave: I followed your instructions and got following message: Compile Error: Expected: expression and two buttons: OK and HELP "Dave Peterson" wrote: Try this: open excel hit alt-f11 (to get to the vbe) hit ctrl-g (to see the immediate window) type this and hit enter: application.commandbars("worksheet menu bar").Enabled = true Now back to excel and try tools|customize|toolbars tab You can select the standard, formatting (and more) toolbars and click reset. Blur wrote: "Ron de Bruin" wrote: Hi Littkerl Do you see other toolbars on your screen ? You can reset your menubar to default Right click on a toolbar and choose customize Under Toolbars select the worksheet menu bar and click on reset If not post back -- Regards Ron de Bruin http://www.rondebruin.nl Hi Ron: My Toolbar also disappeared. Only the formula bar is there. All the other keys (like ALT F, ALT T.. etc do not work) I followed your instructions above and it doesn't work bringing the tool bar back either. Can you help? Cheers soi -- Dave Peterson -- Dave Peterson -- Dave Peterson |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| How do I restore my menu and tool bars in Excell? | Excel Discussion (Misc queries) | |||
| My formula bar disappeared. How do I turn it on? | Excel Discussion (Misc queries) | |||
| Menu Bar - Tools disappeared | Excel Worksheet Functions | |||
| Excell | Excel Discussion (Misc queries) | |||
| Workbook and sheets have disappeared but file can open | Excel Discussion (Misc queries) | |||
Threaded Mode
