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

  • Thread starter Thread starter Simon Lloyd
  • Start date Start date
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
 
P.S I dont want to have to recreate the menubar in VBA as the button
have had the images edited
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Why do i have to re-assign macro's all the time 4
Buttons re-assigned themselves to the right macro name but in Book 1
AddToMru if .xls opened by button assigned to macro within it 2
Excel 2013 menubar incompatibility? 1
How to stop having to re-assign macros every time you open a workbook??? 3
Command/Menu bar & assigned macros 1
Excel 2007 macro assigned to button 3
Macro to open file bypasses Auto_Open 4

Back
Top