Application.WorkbookBeforePrint Event (Excel)
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 |
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