Thread: Prevent User from saving Changes to a spreadsheet
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Gord Dibben Gord Dibben is offline
external usenet poster
  
Posts: 22,906
Default Prevent User from saving Changes to a spreadsheet
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

Reply With QuoteReply With Quote