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

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

On Fri, 7 Nov 2008 14:49:00 -0800, Nigel wrote:

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

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

--
Thanks,
Shane Devenshire


"Nigel" wrote:

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

See how to make Templates here

'Excel Templates' (http://www.excel-it.com/excel_templates.htm)


--
royUK

Hope that helps.

RoyUK
------------------------------------------------------------------------
royUK's Profile: http://www.thecodecage.com/forumz/member.php?userid=15
View this thread: http://www.thecodecage.com/forumz/sh...ad.php?t=26828