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
 

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

Word for iOS 1
Need Help with Macro Security 1
Error After Copying Excel 2003 Macros and Toolbars from Windows Vistato Windows 7 1
Opening a list of Excel files and run a macro in each 17
Template location changes from user to user 0
MS Query 7
Drop down list control value in vba 2
Change a great number of words in word files, with a macro as short as possible. 5

Top