Items missing from Excel Menubar

[Julie]

Last week, I was playing around with adding a custom toolbar to Excel with
Com Add-in. Everything seemed to be working fine. Yesterday I started my
Excel and all of my MenuBar items are missing, except for File and Adobe PDF.
Everything else is gone. Has anyone seen this before? How do I get those menu
items back?

The other wierd thing is that prior to adding my own custom toolbar, I also
installed Microsoft Team System, which also adds a custom toolbar to Excel.
That toolbar is now gone. It is not even available if I right click on the
toolbar. So I'm unsure if my missing menubar items is due to my Com Add-in
(which BTW is still working), or if it's something to do with Team.

Please help!! Thanks in advance!

 

[Julie]

Here is a gif image of my Excel application, with the missing menubar items
(only File and Adobe PDF are present). I need to figure out ASAP how to get
those menubar items back! Thanks!

http://img46.imageshack.us/img46/661/excel8pz.gif

 

[Nick Hebb]

You should post the code that you were playing around with last week.
Also, you could try creating a module in the Excel VBA editor and
running the following to see if they come back:

Public Sub ShowAllMenuItems()

Dim cb As CommandBar

For Each cb In Application.CommandBars
If cb.Type = msoBarTypeMenuBar And _
cb.BuiltIn And _
cb.Visible = False Then
cb.Visible = True
End If
End If
Next

End Sub

Note: I just typed this out in the VBA editor but haven't tested it.


Regards,

Nick Hebb
BreezeTree Software, LLC
http://www.breezetree.com

 

[Julie]

Thanks for the help. I added your code to a sheet and when I ran it, it did
bring back most of the menubar items. It didn't bring back "Data", and there
may still be others missing but I don't remember.

Can someone tell me how to uninstall my toolbar? My registry got modified
when I ran my project for the first time from Visual Studio such my toolbar
gets loaded now even if I'm running Excel outside of Visual Studio. Is there
a way thru Visual Studio to uninstall my toolbar?

 

[Julie]

OK -- I fixed it. I found the resolution in this article:

http://support.microsoft.com/?kbid=327913

I don't know how my Excel11.xlb file got corrupted, but I just renamed it to
Excel11.xlb.old and let Excel recreate a new one. Now everything is working
fine again, including my custom addin toolbar, and also the Microsoft Team
toolbar. YAY!!!

 

[Rohan Salt]

Julie,

You can also reset your menu bar with vba using:

MenuBars(xlWorksheet).Reset