Toolbar created in Workbook to be available when file is opened - how???

[Baldi]

Q: How do I make the button in a toolbar available to all users?

I have created a complicated Excel workbook. To ease the use I have
created a toolbar with some buttons, which trigger a macro.

When other users open the file, they do get the toolbar, but the
toolbar is empty (= the buttons I have are not available although the
macros, which the buttons are to call, are actually stored in the
workbook.

Kind regards
Baldi

 

[Guest]

hi,
I had that problem too.
I solved it by abandoning the icon and put command button
on sheet.

 

[Frank Kabel]

Hi
you have to put some code in your workbook_open event which creates
your toolbar.
Also you may put some code in the workbook_beforeclose event to remove
them afterwards

 

[Dave Peterson]

John Walkenbach has a neat technique that adds an item to the worksheet menubar:
http://j-walk.com/ss/excel/tips/tip53.htm

It's easy to update and looks really professional.

And for toolbars, I like this:
http://groups.google.com/[email protected]