ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   menubar buttons don't appear (https://www.excelbanter.com/excel-programming/289746-menubar-buttons-dont-appear.html)

Janet[_5_]

menubar buttons don't appear
 
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[_3_]

menubar buttons don't appear
 
Janet wrote:

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,
--
Beto
Reply: Erase between the dot (inclusive) and the @.
Responder: Borra la frase obvia y el punto previo.



All times are GMT +1. The time now is 02:04 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com