I periodically run into a problem with custom buttons on my Excel
toolbar linked to macros in my personal.xls file where the actual
location (drive and/or folder) of personal.xls no longer matches what is
associated with the custom button on the toolbar. For example, I get a
new computer and decide to install Windows and Excel on drive "D"
instead of drive "C". [Don't ask why... it's a long story!] I install
Excel and copy my old personal.xls into the appropriate folder onthe new
drive "D" but the custom button on the toolbar still thinks personal.xls
is on drive "C". This results in the old "two copies of personal.xls
have been opened" error message and the macros don't work.

I can fix the problem by going into tools:customize:macros, highlighting
the button, and usin modify selection to manually reassign each button
to the correct location for personal.xls, but by now I have about 20
custom buttons and it's a pain. Is there some secret file or registry
entry that stores information about custom buttons where I could go in
and change the drive/folder locations a little more easily? I think yes
since I apparently accomplished it last week... I just don't know what I
did!

Any help deeply appreciated.




*** Sent via Developersdex http://www.developersdex.com ***