Hi! I've tried trapping printing as per the thread "Workbook_BeforePrint(Cancel As Boolean) ...how about AfterPr" at http://www.mrexcel.com/forum/excel-questions/1659-workbook_beforeprint-cancel-boolean-how-about-afterpr.html.
As mentioned in the thread, the same code runs for both Print and...