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

See also

Workbook Object