Custom Menu

[Jimbob]

Hi
When i create a custom menu with some buttons and i save it, and then i open
the file on a different computer, the custom menu's have disappeard. Any
pointers?
TIA

 

[Guest]

Do you load the custom menu's At the on_open event for the sheet. In
ThisWorkbook use the On_open and On_Close events to load and unload the
menus...

HTH

 

[Tom Ogilvy]

You have to attach the custom menu to the file - Tools=>Customize then
toolbars tab, click the attach button.


Here is an article which talks about attaching toolbars:
http://www.microsoft.com/exceldev/articles/toolbatt.htm

 

[Jimbob]

You have to attach the custom menu to the file - Tools=>Customize
then toolbars tab, click the attach button.


Here is an article which talks about attaching toolbars:
http://www.microsoft.com/exceldev/articles/toolbatt.htm

Great stuff, done it! Thanks