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


--
Preet
------------------------------------------------------------------------
Preet's Profile: http://www.excelforum.com/member.php...fo&userid=3155
View this thread: http://www.excelforum.com/showthread...hreadid=395257