Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Excel v2003
I have many custom tool buttons on my tool bars that are assigned to macros from my personal.xls. Upon getting a new computer, I restored all those buttons using my old Excel11.xlb file and put my old personal.xls back in the XLSTART folder. However, the path to my personal.xls is slightly different on the new notebook. It was: C:\Documents and Settings\Melina\Application Data\Microsoft\Excel \XLSTART\PERSONAL.XLS It's now: C:\Documents and Settings\Mel\Application Data\Microsoft\Excel\XLSTART \PERSONAL.XLS So, now my buttons won't work because they're looking for the old path. I could change the path of each in the macro assignments, but is there a way or code to mass-change the path to these macros or do I have to change them one at a time? Thanks for your advice. -Mel |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
how do I change macro relative reference? no stop recording tool | Excel Discussion (Misc queries) | |||
Mass amounts of buttons | Excel Programming | |||
Mass Change Hyperlinks | Excel Programming | |||
Mass Change Across Many WorkBOOKS | Excel Discussion (Misc queries) | |||
Macro to perform mass header change on 100 worksheets | Excel Programming |