Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Victor
 
Posts: n/a
Default Menu and toolbars are missing

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   Report Post  
Bob Phillips
 
Posts: n/a
Default

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   Report Post  
Jim Rech
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Keep Custom Menu settings - help !! Anthony Excel Worksheet Functions 1 February 26th 05 12:11 AM
Excel menu dissappears Dan Jurden Excel Discussion (Misc queries) 1 February 15th 05 02:25 PM
In excel 2003, the menu bar and all toolbars disappear JackCraig46 Excel Discussion (Misc queries) 1 January 29th 05 12:28 AM
Transferring toolbars and macros to other computers Darrell Excel Discussion (Misc queries) 1 January 19th 05 12:21 AM
Stubborn toolbars in Excel 007 Excel Discussion (Misc queries) 9 December 11th 04 02:02 PM


All times are GMT +1. The time now is 01:15 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"