| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro Name problem when I change workbook 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 | |||
| Macro change problem | Excel Discussion (Misc queries) | |||
| Macro broken with workbook name change | Excel Discussion (Misc queries) | |||
| Macro to change worksheets in the same workbook | Excel Discussion (Misc queries) | |||
| Problem closing a workbook using a macro | Excel Programming | |||
| A Macro to change macros? VBA problem | Excel Programming | |||
Threaded Mode
