Prevent User from saving Changes to a spreadsheet

N

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
 
G

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
 
S

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
 
Top