Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Macro: Copy a worksheet and rename it to a specified value | Excel Discussion (Misc queries) | |||
Copy, Paste and Rename a Range using a macro | Excel Discussion (Misc queries) | |||
Macro REQ: Automatically copy a template sheet and rename | Excel Worksheet Functions | |||
How to rename references from range names to cell references | Excel Discussion (Misc queries) | |||
Run Macro & Rename Sheet upon creating copy from blank. | Excel Programming |