| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| not able to assign macro | Excel Discussion (Misc queries) | |||
| Assign Macro | Excel Discussion (Misc queries) | |||
| Assign Macro | Excel Worksheet Functions | |||
| assign macro | Excel Worksheet Functions | |||
| Un-assign a macro | New Users to Excel | |||
Hybrid Mode
