Workbook.BeforePrint Event (Excel)
Occurs before the workbook (or anything in it) is printed.
expression A variable that represents a Workbook object.
|Cancel||Required||Boolean||False when the event occurs. If the event procedure sets this argument to True , the workbook isn't printed when the procedure is finished.|
This example recalculates all worksheets in the active workbook before printing anything.
Private Sub Workbook_BeforePrint(Cancel As Boolean) For Each wk in Worksheets wk.Calculate Next End Sub