- Joined
- Oct 5, 2005
- Messages
- 1
- Reaction score
- 0
Hi Everybody,
Could someone tell me how to create a macro which does not get replaced even if I replace the file in which the macro was created.
I know that storing the macro in "Personal.xls" would be a good option here, but that would only let me run the macro. Isn't there a way of creating a permanent macro in a workbook that would remain even though I might replace the old excel file with the new one!
Thanks and Regards
Divakar Khanna
Could someone tell me how to create a macro which does not get replaced even if I replace the file in which the macro was created.
I know that storing the macro in "Personal.xls" would be a good option here, but that would only let me run the macro. Isn't there a way of creating a permanent macro in a workbook that would remain even though I might replace the old excel file with the new one!
Thanks and Regards
Divakar Khanna