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

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

Thanx a lot




CurlyDave wrote:

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