Home |
Search |
Today's Posts |
|
#1
![]() |
|||
|
|||
![]()
I ran a macro recently from a very reliable source. afterwards, the menu and
toolbars stopping appearing when I would open up excel. I have right and left clicked everything on the spreadsheet, and nothing. I have also searched all my files for .xlb files, as previousy suggested, even my hidden files, and no file came up with that extension. What do I do? Would the .xlb file be on the CD? Thanks, Victor |
#2
![]() |
|||
|
|||
![]()
Probably just disabled.
Try this. In the VBE immediate window, type Application.Commandbars(1).Enabled=True You then can go to ToolsCustomize and check all the toolbars (Formatting, Standard, etc.) -- HTH RP (remove nothere from the email address if mailing direct) "Victor" wrote in message ... I ran a macro recently from a very reliable source. afterwards, the menu and toolbars stopping appearing when I would open up excel. I have right and left clicked everything on the spreadsheet, and nothing. I have also searched all my files for .xlb files, as previousy suggested, even my hidden files, and no file came up with that extension. What do I do? Would the .xlb file be on the CD? Thanks, Victor |
#3
![]() |
|||
|
|||
![]()
I have also searched all my files for .xlb files, as previousy suggested,
even my hidden files, and no file came up with that extension. But you should have this file as all changes to the default menu/toolbar setup are saved there. Specially look in: C:\Documents and Settings\<your user name\Application Data\Microsoft\Excel If an XLB file is there just delete or rename it (with Excel closed), if Bob's solution doesn't do what you want. -- Jim Rech Excel MVP "Victor" wrote in message ... |I ran a macro recently from a very reliable source. afterwards, the menu and | toolbars stopping appearing when I would open up excel. | | I have right and left clicked everything on the spreadsheet, and nothing. I | have also searched all my files for .xlb files, as previousy suggested, even | my hidden files, and no file came up with that extension. | | What do I do? Would the .xlb file be on the CD? | | Thanks, | Victor |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Keep Custom Menu settings - help !! | Excel Worksheet Functions | |||
Excel menu dissappears | Excel Discussion (Misc queries) | |||
In excel 2003, the menu bar and all toolbars disappear | Excel Discussion (Misc queries) | |||
Transferring toolbars and macros to other computers | Excel Discussion (Misc queries) | |||
Stubborn toolbars in Excel | Excel Discussion (Misc queries) |