Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
Hi everyone,
Say I have a recorded macro named "Base" and linked it to a button in a an excel workbook named ABC.xls Later, say I changed the file name to DEF.xls Now, when I click on the 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 | |
|
|
![]() |
||||
Thread | Forum | |||
Can't get simple macro to run | Excel Worksheet Functions | |||
Change Row Numbers in Formula with Macro | Excel Discussion (Misc queries) | |||
Where to stick macro to change default comment font? | Excel Discussion (Misc queries) | |||
Macro Formula revision? | Excel Worksheet Functions | |||
Macro button colour change??? | Excel Worksheet Functions |