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