Assign Macro problem

  • Thread starter Thread starter Tonmai K.
  • Start date Start date
T

Tonmai K.

Hi,
I have some problem about assigning macro.
I assign macro on some place on workbook and save this
file to one folder. After I copy this file to another
folder, the assigned macro always point to file at old
location. I would like the assigned macro change with new
location. Can I?

Thanks in advanced for any help.
Tonmai K.
 
Look at the onaction property of the object you assigned the macro to. You
can have your workbook_open event reassign the macro when you open it.

Regards,
Tom Ogilvy
 
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

Assigned macro change 5
Excel 2007 macro assigned to button 3
assign macro - toolbar 2
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
assigning macro 2
Assigned Macro to button 5
Assign macro 2
How to call Excel add-in macro from a button… 1

Back
Top