Figure The events for a workbook object

1 ¡Worfcfaaok -r I

before Close -*

Option Explicit

ltetnrF=Cl(isp

re Print BefareSare Deactivate NewShsel Opt n

SheetActivale

Sh eetB efDreDou bl eC lick

Sh eetB efDreRigfttC lick

SheetCateulate!

Shi^tQ hange

SheetDe4CliV9te

_

' Delete custom menu

Dim r fts Integer Dim As Worksheet Din sNamp As String

' -tn ... 4- . |-„ T1

If, for example, we choose the BeforeClose event in the Procedures box, Excel will create the following code shell for this event and place the cursor within this procedure:

Private Sub Workbook BeforeClose(Cancel As Boolean) End Sub

0 0

Post a comment