Hyperlink Bug
 

I have one workbook that creates other workbooks based off
a template and stores in a generic directory. The sheet
also creates a hyperlink to these files. But, when you
select the hyperlink to open the file, all the properties
of the template are changed and it messes up the entire
application.
If I open the created file independantly, there is no
problem.
Can anyone help me with this?