Figure The events for a workbook object

1 ¡Worfcfaaok -r I

before Close -*

Option Explicit


re Print BefareSare Deactivate NewShsel Opt n


Sh eetB efDreDou bl eC lick

Sh eetB efDreRigfttC lick


Shi^tQ hange



' 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