| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Macros don't work when file name changes
I created a workbook with many macros using the simple "record macro" tool.
This fiel was saved in *.XLS format. It is intended to be a master fille and when you fill it out as a form you re-save it with a new name. the problem I am running into is that after I re-save it wit a new name the Macros won't work properly. I get an error message and when I click to run the debugger the macro lists the original workbook name. How do I fix this so that the macros work regardless of file name? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Macros do not work anymore! | Excel Discussion (Misc queries) | |||
| PC macros won't work on MAC | Excel Discussion (Misc queries) | |||
| how do i use macros to work out commissions | Excel Worksheet Functions | |||
| Solver does not work from Macros | Setting up and Configuration of Excel | |||
Threaded Mode
