Prevent User from saving Changes to a spreadsheet

[Nigel]

How do I code it so a user cannot save changes to a template report BUT still
be able to make changes to the data.

The idea is that they would retrieve essbase data into a template and then
once they are done be prevented from saving any changes to the template

 

[Gord Dibben]

Make it a true Template and a new workbook will be generated which user can
save or not after they are through with it.

The Template remains untouched.


Gord Dibben MS Excel MVP

 

[ShaneDevenshire]

Hi,

And how does one make a template -
1. Design the file
2. Choose Save As
3. In the Files of Type change to Template (*.xlt) this will switch you to
the Templates folder.
4. Name the file and click save.

When the user wants to use the template have them choose File, New, and
click Templates, On my computer... in the New Workbook task pane.
They pick your template and when it opens it is a regular spreadsheet not a
template and is handled just like Book1