View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Bill Cockerill Bill Cockerill is offline
external usenet poster
 
Posts: 1
Default Macros assigned to buttons do not work when copied to CD

Dear Group,

I have built a workbook with a custom toolbar.

The buttons on the toolbar are assigned to macros in the workbook.

However, when I copy the workbook to a CD and run it from there, it
tries to run the macros from the original workbook, not the CD copy.

It then tells me I can't have two workbooks of the same name open!

How can I assign macros to buttons that work from that workbook, no
matter where it is copied to?

Thanks, Bill