Save on closing file
 

All-
I am looking for code that will save a file automatically when the user
closes the file. This file has no macro and I would like to use this code on
multiple files. What do you suggest?

Thanks in advance!
--
EW - Analyst

Save on closing file
 

Look at Application Level Events

http://www.cpearson.com/excel/appevent.htm

You would use the beforesave event.

--
Regards,
Tom Ogilvy

"ewagz" wrote in message
...
All-
I am looking for code that will save a file automatically when the user
closes the file. This file has no macro and I would like to use this code
on
multiple files. What do you suggest?

Thanks in advance!
--
EW - Analyst