For some reason, I didn't get it the first time, but now I understand.
YES, it worked beautifully. Thank you! That saved me a ton of time!

-Mel

On Feb 11, 11:47*am, "Peter T" <peter_t@discussions wrote:
Is this closing one and opening the other workaround what
you were suggesting?

Open the file in the folder with the correct links (all buttons should
work). Then SaveAs the file in the new folder (all the buttons should still
work). Did you try following the steps I suggested last time.

Regards,
Peter T

"Mel" wrote in message

...
Each session of opens the personal.xls from the default path, which is
now ...\Mel\... , but used to be ...\Melina\... . As a workaround I
have created the old path and placed a copy of the personal.xls in it.
In Excel I can then close the default ...\Mel\...\personal.xls and
open ...\Melina\...\personal.xls and of course the buttons will then
work. That's because the personal.xls now open has the correct path as
in the properties of the buttons' assigned macros. But it's a mess to
have to close one and open the other each time I start Excel, not to
mention I may end up maintaining two personal.xls files.

Is this closing one and opening the other workaround what you were
suggesting?

On Feb 11, 9:57 am, "Peter T" <peter_t@discussions wrote:

Forgot to add, as normally Personal is hidden you may find it easier to do
your SaveAs and Close from the Immediate window, Ctrl-G

Make sure you select your Personal each time, type things like the
following
and with the cursor at the end of the line hit Enter.

?thisworkbook.fullname

thisworkbook.saveas "new fullname"

thisworkbook.close

Peter T

"Peter T" <peter_t@discussions wrote in message

...

Close your Personal.
Rename the Personal in the new folder
Open the original Personal from the *old* folder
SaveAs Personal with same name but in the *new* folder.

If the two personal's are not the same, delete the recently SaveAs file
and restore the renamed Personal in the new folder (assuming of course
the
new Personal has similarly named macros).

Regards,
Peter T

"Mel" wrote in message
....
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