ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   How do you assign macro's to new menu with buttons on Auto_open? (https://www.excelbanter.com/excel-programming/302246-how-do-you-assign-macros-new-menu-buttons-auto_open.html)

Simon Lloyd[_502_]

How do you assign macro's to new menu with buttons on Auto_open?
 
I have some workbooks that all contain the same code give or take a fe
minor changes, and the all use the same menu bar i created and all us
the same macros for the buttons on this menu bar, my problem is when
open the workbook on another networked machine i have to re-assig
macros and i pretty much have to do this every time, the workbook is o
a network drive that can be accessed from any PC.

Can anyone help with this?

Thanks,

Simo

--
Message posted from http://www.ExcelForum.com


Simon Lloyd[_506_]

How do you assign macro's to new menu with buttons on Auto_open?
 
P.S I dont want to have to recreate the menubar in VBA as the button
have had the images edited

--
Message posted from http://www.ExcelForum.com


Simon Lloyd[_509_]

How do you assign macro's to new menu with buttons on Auto_open?
 
Has anyone got any ideas on this?

Need help with this!


Simo

--
Message posted from http://www.ExcelForum.com



All times are GMT +1. The time now is 03:38 AM.

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