Worksheet_Activate

[greg]

There is an excel with 2 sheets sheet1 and sheet2 with their respective
Worksheet_Activate
methods. on going from sheet1 to sheet2 and back(in debug mode) the
respective Worksheet_Activate methods are being invoked.

I added a new sheet sheet3 . now the Worksheet_Activate for sheet3 is
not invoked...

any clues please

 

[CurlyDave]

Did you use the workbook module, instead of a worksheet module??such As

Private Sub Workbook_SheetActivate(ByVal Sh As Object)
MsgBox "hi"
End Sub

 

[greg]

Thanx a lot