| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Macro problem where workbook name is saved in another name and macro reference changes
Hello, Excel 2003 and 2007. I have numerous macros in my spreadsheet and
have been forced to change the name of the worksheet and workbook over the past few weeks. Today I sent the worksheet out to others in my group and some of the macros refer directly to the pages within the workbook, but some of the macro's show the entire path (which doesn't esist anymore) and won't work. Does anyone have any ideas or know of a way to keep the macros references directly to the existing workbook, no matter where it's located. Thanks Bob R |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| macro runs when workbook is saved, but only with vba change... | Excel Programming | |||
| Macro to alert when workbook saved or updated?? Is this possible? | Excel Programming | |||
| Problem in updating all worksheets of a workbook using a macro that calls another macro | Excel Programming | |||
| How do you run macro automatically each time workbook is saved? | Excel Programming | |||
| Run a macro each time a workbook is saved | Excel Programming | |||
Threaded Mode
