Missing Menu and Toolbar

  • Thread starter Thread starter Aaron Okinaga
  • Start date Start date
A

Aaron Okinaga

Hi,

Somehow one of our users had made the menu and toolbars
disappear from Excel. At the very top starts the columns
without any room for the menu or toolbar. How can I
restore this if I can't see the menu nor toolbar?

Thank you,
Aaron
 
Try to run this macro

Sub test()
Application.CommandBars(1).Enabled = True
End Sub

Post back if you have problems
 
Hi Ron,

Thank you. I know that this maybe a stupid question but
how do I run the macro if I can't bring up the macro
screen. We only have Excel loaded on this machine and are
running Windows 2000. I just noticed that you can't right
click in the spreadsheet to bring up the short cut menu to
cut, paste, format, etc. Any thoughts on how to run this?

Thank you,
Aaron
 
Hi Aaron

Alt -F11
Insert module from the menubar
paste the sub
Alt-Q to go back to excel

Alt-F8
select the macro and click on run
 
Hi Ron,

Thank you very much! It worked perfectly. I have another
problem now. The toolbars that were standard with Excel
are no longer there. The only toolbars available are the
Task Pane and Worksheet Menu Bar. Would you recommend a
reinstall of Excel, manually re-create the toolbars or is
there something easier?

Thank you so much,
Aaron
 
Thats what I was looking for although I tried it once and
missed the (1). You folks are a lifesaver
 
A question relating to this please.
What does the (1) actually refer to and what happens if you change this
value?
Rob
 
Rob,

The (1) refers to the worksheet menu bar. If you change that value, you'll
be referring to another command bar. You can get a complete list of command
bars and their index numbers with the following code:

Dim Ndx As Long
With Application.CommandBars
For Ndx = 1 To .Count
Cells(Ndx, 1).Value = Ndx
Cells(Ndx, 2).Value = .Item(Ndx).Name
Next Ndx
End With


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting, LLC
www.cpearson.com
 
Hi Rob,

I did that but it only shows 2 tool bars, Task Pane and
Worksheet Menu Bar. Normally it'll show other tool bars
like Standard, Formatting, Borders, etc. Do you know if I
would need to reinstall Excel or re-create them manually?

Thank you,
Aaron
 
Before you install, try a little macro:

Option Explicit
Sub testme()
Dim myCB As CommandBar
For Each myCB In Application.CommandBars
myCB.Enabled = True
Next myCB
End Sub

Hit Alt-F11
insert|module
paste that code in

Back to excel and see if it's ok.

If it is, woohoo!

But if it's not, you could trash all your commandbar settings by renaming your
*.xlb file to *.xlbOLD.

Then start excel and see if it's ok. If it is, you could rebuild the toolbars
(and dump the *.xlbOLD file).
 
Woohoo Dave!

You are awesome! That code worked and now all tool bars
appear for me to choose from. Thank you very much!!!

I'm glad that we have you guys to help us! Thank you
Excel gurus!!!

Aaron
 
Back
Top