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
 
Back
Top