Choosing the right Workbook to save

[ABabeNChrist]

What is the best method to preserve a workbook in its original form, from being altered or changed or even possible corruption?
My Workbook has variety of merged cells, Formulas and VBA
Should it be saved as an Excel Macro-Enabled Workbook or Excel Binary Workbook or Excel Macro-Enabled Template?
And then should I select the read only or will this take away some of the features

[HansV]

Whaty exactly do you want to accomplish?

[ABabeNChrist]

Hi HansV
This Workbook is used to do various types of reports. When the report is completed it would then be printed and or sometimes saved.
I need to keep an original or master intact, I don’t wish for it to save changes, so that each time I open this Workbook it will be ready to start a new report. To save as would be OK.

[HansV]

I'd save it as an Excel Macro-Enabled Template (.xltm). If the user opens it directly from Windows Explorer, Excel will create a new workbook based on the template. And if you store the template in the user templates folder or workgroup templates folder, it'll be available when you click Office | New.

[ABabeNChrist]

Hi HansV

And if you store the template in the user templates folder or workgroup templates folder, it'll be available when you click Office

That interesting I didn’t know that.....
I was also wondering do I need to select on the properties to read only or is that not needed.

[HansV]

Making the template read-only may help a bit, but not much - it's easy to bypass.

[ABabeNChrist]

Very Cool, Thank you HansV