| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Changing Macro Name?
Hi everyone,
Say I created a macro I named "Base" in a an excel workbook named ABC.xls Later, say I changed the file name to DEF.xls Now, when I click on the macro button to execute, I get "out of range" error and the file close! How can I make the macro name is independent of the file name; so it doesn't keep referring to the old file name? Regards, Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Why is my macro changing sum to count? | Excel Discussion (Misc queries) | |||
| Help with changing a Macro | Excel Discussion (Misc queries) | |||
| Help with changing a Macro | Excel Discussion (Misc queries) | |||
| Macro Ran in Excel 97 but in XP. What Needs Changing | Excel Programming | |||
| Macro for changing tabs | Excel Programming | |||
Threaded Mode
