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.