Opening a copy of an excel workbook and retaining original unchanged

[Nicodemus1960]

I have a 'master' workbook which I want to make available to users but I want to be able to open a copy of the workbook and retain the master copy unchanged.  Is there a Vba code to enable this?  I have tried a few things using the 'before open' event but am unable to find the correct code.

[#2 · Accepted solution]

@Nicodemus1960 

Save the workbook as an Excel Template (*.xltx), or if it contains VBA code, as an Excel Macro-Enabled Template (*.xltm).

The default action for a template is to create a new workbook from the template.

[#3]

Hi Hans

Excellent thank you