Occurs before any open workbook is printed.
Syntax
expression.WorkbookBeforePrint (Wb, Cancel)
expression A variable that represents an Application object.
Parameters
| Name | Required/Optional | Data type | Description |
|---|---|---|---|
| Wb | Required | Workbook | The workbook. |
| 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 workbook before printing anything.
Private Sub App_WorkbookBeforePrint(ByVal Wb As Workbook, Cancel As Boolean)
For Each wk In Wb.Worksheets
wk.Calculate
Next
End Sub