View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Peter T Peter T is offline
external usenet poster
 
Posts: 5,600
Default Can I mass-change macro paths of tool buttons?

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