Workbook.BeforePrint Event (Excel)
Occurs before the workbook (or anything in it) is printed.
Syntax
expression .BeforePrint(Cancel)
expression A variable that represents a Workbook object.
Parameters
Name |
Required/Optional |
Data Type |
Description |
|---|---|---|---|
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. |
Return Value
Nothing
Example
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