View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
BOBJ BOBJ is offline
external usenet poster
 
Posts: 1
Default Copy/Rename XLS and Macro References

Does anyone know how to have the Macros in my XLS file NOT have to reference
the orginal file position? I have created a toolbar button that runs a
macro. When I copy this XLS to another machine or rename the file, it can no
longer find the Macro since it is trying to find it in the original file.
The only way I can fix it is to "Assign Macro" again to the button. This is
not good as I need to distribute this XLS to other users. Is there a way
around this? The same problem occurs in the menus.

Thanks, -BOBJ