move macros to a new location

  • Thread starter Thread starter Ken
  • Start date Start date
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?
 
I would put the macros in your "personal.xls" workbook, then reassig
the icons to the macros in that location.

HT
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

moving the cursor in a macro 1
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Problem (bug?) in the way Excel 2007 doesn't automatically load ma 8
Assigning Macros to Toolbar buttons 1
Macro Buttons 3
Macro to use information in a cell to locate and send files using outlook 0
Macros location 4
vba macro that allows insertion of symbols at cursor 0

Back
Top