Assign Macro problem
 

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.

Assign Macro problem
 

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


"Tonmai K." wrote in message
...
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.