Excel template not functioning properly when opened from a hyperlink

[doublej41]

Hi All

I have created an Excel template file for use when inputting data. As part of the system we are implementing this file will be opened by means of a hyperlink from another Excel file.

When double clicking the file to open it directly, the template functions properly i.e. only allows a 'save as'. However, when the file is opened from the hyperlink it does not disable the save function, therefore allowing the user to save over the template.

Does anyone know what might be causing this to happen, and what I can to to prevent it? Any insight will be greatly appreciated.

Thanks

Jonathan

 

[Andrew Poulsom]

Yes, a hyperlink will open the template for editing. The only thing I can suggest is to use a macro to add a new workbook based on the template. Assign it to a shape or CommandButton if you want.

 

[doublej41]

Thanks for the reply; I will look at setting up a macro.

Is there any particular reason a hyperlink causes a template to function incorrectly?

 

[Andrew Poulsom]

When you choose File|Open to open a template the original is opened for editing. It's only when you choose File|New that you get a copy. A hyperlink does the former.

 

[doublej41]

Thanks for explaining.

Have now set up a macro and its working as expected.