Closing a spreadsheet?! Please HELP!
 

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

Closing a spreadsheet?! Please HELP!
 

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 FileSave As as select Template under "Save As Type".

NickHK

"Preet" wrote in
message ...

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