menubar buttons don't appear

[Janet]

Hi,

I've added 2 menubar buttons that run macros (opens a
calendar and autofits text) to a shared workbook.
However, my computer is the only one that shows the
buttons on the toolbar. What do I need to do so everyone
who gets it off the shared can see it? They can do the
keyboard shortcut for it and view the macro code, but the
button isn't appearing in their toolbars.

Thanks,

Janet

 

[Beto]

Hi,

I've added 2 menubar buttons that run macros (opens a
calendar and autofits text) to a shared workbook.
However, my computer is the only one that shows the
buttons on the toolbar. What do I need to do so everyone
who gets it off the shared can see it? They can do the
keyboard shortcut for it and view the macro code, but the
button isn't appearing in their toolbars.

You must create the buttons on the fly on the workbook_open event, I
can't remember how exactly, I've done it with the help of some examples
found through google groups search. I advice you to do the same.

Regards,