Save on closing file

[ewagz]

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

[Tom Ogilvy]

Look at Application Level Events

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

You would use the beforesave event.

--
Regards,
Tom Ogilvy

"ewagz" <[email protected]> wrote in message
news:[email protected]...
> 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