Choosing the right Workbook to save

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Choosing the right Workbook to save

Post by 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

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Choosing the right Workbook to save

Post by HansV »

Whaty exactly do you want to accomplish?
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Choosing the right Workbook to save

Post by 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.

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Choosing the right Workbook to save

Post by 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.
Best wishes,
Hans

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Choosing the right Workbook to save

Post by 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.

User avatar
HansV
Administrator
Posts: 78370
Joined: 16 Jan 2010, 00:14
Status: Microsoft MVP
Location: Wageningen, The Netherlands

Re: Choosing the right Workbook to save

Post by HansV »

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

ABabeNChrist
SilverLounger
Posts: 1868
Joined: 25 Jan 2010, 14:00
Location: Conroe, Texas

Re: Choosing the right Workbook to save

Post by ABabeNChrist »

Very Cool, Thank you HansV