Hello,
Say I have a macro-enabled workbook and I manually go to the file folder and make a copy of it (not with VBA), just simply make a copy.
The workbook is of course renamed with a whole new file name. The reason I am doing this is because I want to re-use the macros in it, and I am only changing some information on the worksheets.
So, assume, the macros work just fine in both workbooks. Is it necessary to rename the macros, giving them unique names?
I also have no reason to have or use both workbooks at the same time, but in the event I leave one open by accident, would something bad happen if the macros remained with the same names?
I have made copies of workbooks before, and for some reason "I think" I can feel or get a sense of something that isn't smooth.
It's like they say about "cloning" they look the same but the personalities most likely will be different LOL.
Is it me, or is something strange occuring?
I thank you in advance.
- Nej
Say I have a macro-enabled workbook and I manually go to the file folder and make a copy of it (not with VBA), just simply make a copy.
The workbook is of course renamed with a whole new file name. The reason I am doing this is because I want to re-use the macros in it, and I am only changing some information on the worksheets.
So, assume, the macros work just fine in both workbooks. Is it necessary to rename the macros, giving them unique names?
I also have no reason to have or use both workbooks at the same time, but in the event I leave one open by accident, would something bad happen if the macros remained with the same names?
I have made copies of workbooks before, and for some reason "I think" I can feel or get a sense of something that isn't smooth.
It's like they say about "cloning" they look the same but the personalities most likely will be different LOL.
Is it me, or is something strange occuring?
I thank you in advance.
- Nej