How do you assign macro's to new menu with buttons on Auto_open?

S

Simon Lloyd

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
 
S

Simon Lloyd

P.S I dont want to have to recreate the menubar in VBA as the button
have had the images edited
 
Top