Menu and toolbars are missing

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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
 
Probably just disabled.

Try this. In the VBE immediate window, type

Application.Commandbars(1).Enabled=True

You then can go to Tools>Customize and check all the toolbars (Formatting,
Standard, etc.)

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
I have also searched all my files for .xlb files, as previousy suggested,
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
|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
 
Back
Top