Closing a spreadsheet?! Please HELP!

[Preet]

Please can someone help me

I have a spreadsheet, which acts as a template for a report – on
clicking of a button it populates this report through a csv file, then
applies a autofilter to the fields. At this point the user can save the
report, but what I am looking for is on closing of this template, I do
not want the user to be able to save the template - as it has been
populated and wont be blank.

So the question if : *What would the code be for “On close/quit of the
template do NOT save any changes to this template” *
Is there a macro that can auto execute if the user goes to file > exit
or closes the application – that then wont save any changes made to the
template?

Thank you in advance for looking at this!

x

 

[NickHK]

Preet,
If it is a "real" Excel template, with a .xlt extension, then everytime you
(normally) open it, you actually open a copy.
The original remains unchanged.
Hence no need to check the saving, for this reason anyway.
Check out File>Save As as select Template under "Save As Type".

NickHK