Macro icons on menu bar disappearing

[Michael Singmin]

Hello Group,

I have several icons on the menu bar linked to macros.
This is in a Lims system for a technolgy department.
Today all my private icons disappeared - What could have caused this ?

When I create an icon linked to a macro - where is this stored ?

Thanks,

Michael Singmin

 

[Bob Flanagan]

Michael, the icons are stored in the XLB file which is normally in the
Windows directory. But I have found them in other directories. Typically
the name is the username of who logged onto the PC. The way to find is to
search the whole machine for XLB filetypes and the most recent modified is
the one associated with the last Excel session. I have found it useful to
hide copies of this file so that it is easy to restore menu bar
customization..

Bob Flanagan
Macro Systems
http://www.add-ins.com
Productivity add-ins and downloadable books on VB macros for Excel

 

[Gord Dibben]

Michael

Menus and Buttons can be created "on the fly" by VBA code.

OR the buttons could be created using Tools>Customize.

If the former, could be your auto-open or workbook_open code is not firing.

If the latter, the customizations are saved in an *.XLB file.

Do a file search for *.XLB file. There may be more than one so note where
they are and make changes to your menus or toolbar and see which *.XLB file is
altered. Make a backup copy of it so's you can replace if it gets lost again.

Usually stored in your Documents and Settings\Username
Application Data\Microsoft\Excel folder.

If on a network, the *.XLB filepath can get lost.

Gord Dibben Excel MVP

 

[Michael Singmin]

Thank you Bob and Gord,

After reading about the vagaries of the XLB structure,
I decided on protecting the toolbar with
Commandbars ("Worksheet menu Bar").Protection = msoBarNoCustomize

Thanks for your assistance,

Michael