Worksheet_Activate

  • Thread starter Thread starter greg
  • Start date Start date
G

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
 
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
 
Back
Top