Good day all, I wonder if anyone has come across this before?

I have a 'private sub' macro which runs when a template is opened. The utility of this is to assign an incremental Project ID to the template each time it is opened. Obviously, the template is then saved under a different name...as well as being saved as an .xls file.

The problem: The private sub code is still there when the new named worksheet is opened and the increment still clicks up one number everytime the sheet is opened. I have been trying to write code to insert after the existing code in the .xlt file which will effectively delete the code once the template has assigned a number.

I am afraid I have not been able to do this, so any help would be greatly appreciated.

Thank you.