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
Forum Rules