Assign Macro problem

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.
 
T

Tom Ogilvy

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
 
Top