Quote Originally Posted by rory
You can use the Workbook_BeforeSave and Workbook_BeforePrint events for this. Code need to go into the ThisWorkbook module of your workbook.
HTH
Rory
just a quick hijack here..
these functions are only available in office 2007 ?

cheers