move macros to a new location

K

Ken

I had some icons in the toolbar linked to a macro. I
moved the file to a new location and when I click the
icon now I get an error that "the macro xxxxxx cannot be
found". How do I fix this?
 
S

swatsp0p

I would put the macros in your "personal.xls" workbook, then reassig
the icons to the macros in that location.

HT
 
G

Gord Dibben

Ken

Personal.xls must reside in your XLSTART folder in order for Excel to open it
when Excel starts up.

Move it to another folder and Excel can't find it.

Gord Dibben Excel MVP
 
Top