Inserting a new template sheet (cyclic issues)

Hey guys,

OllieB was an amazing help to me the other day with code that would allow me to import a template sheet from a second file into the open file I was working on. Everything worked perfectly until I tried to activate the macros within one of the sheets that had been imported. I found that the macro from the imported template sheet referenced the code within the template file, and did not change it's reference to the open file. The result is that I cannot import a new sheet from an imported sheet.

I hope everyone can follow what I am saying!

Essentially every sheet that the operator has access to will have the macro embedded into it. As one sheet is filled out, the operator should be able to click on the completed sheet (that was originally imported from the template file) and import another sheet.

I'm certain that it's an issue with the linking of the macro to the template file. As the open file will ultimately have different save names, I can't hard code the macro location into the template file. Is there a way that I can soft code the macro so that it will always reference the sheet that the macro is embedded in, and not the original sheet in the template file where it is stored?

Please Login or Register  to view this content.

Thank you!

Please Login or Register  to view this content.

This template file will remain constant - but the target files will change name and location. I find that once I import a sheet from the template, as stated, the macro references back to the above file, and not the macro code embedded within the target file.