Can't get Worksheet_Activate() to work in one spreadsheet.

[clay]

Private Sub Worksheet_Activate()
MsgBox "Help"
End Sub

This MsgBox or any code will not execute. This code is placed in the Sheet.

 

[Claus Busch]

Hi Clay,

Am Fri, 16 Aug 2013 09:59:31 -0700 (PDT) schrieb clay:

This code is placed in the Sheet.

right click on sheet tab => Show code and paste your code into the code
window of this sheet


Regards
Claus B.

 

[isabelle]

hi,

execute the following code to reactivate events

Sub Macro1()
Application.EnableEvents = True
End Sub

isabelle

Le 2013-08-16 12:59, clay a écrit :

 

[clay]

hi,



execute the following code to reactivate events



Sub Macro1()

Application.EnableEvents = True

End Sub



isabelle



Le 2013-08-16 12:59, clay a écrit :

Isabelle,

Thank you. That fixes the problem.