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