Can I run a macro/program when Excel saves worksheet?

[Guest]

I'm desperate to find out how I can run a macro or vba program when the file
is saved (or even when Excel quits). I've read that I can run a macro for
example when Excel starts using Auto_Start but I don't know of any other
prenamed macros that I can use.

My overall aim is to save the file in two formats (one Excel and the other
HTM for the Intranet site) but I want this to be invisible to all users of
the spreadsheet.

Thanks in eager anticipation,

Terry

 

[Frank Kabel]

Hi
you could use the workbook_beforesave event. See:
http://www.cpearson.com/excel/events.htm