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

  • Thread starter Thread starter clay
  • Start date Start date
C

clay

Private Sub Worksheet_Activate()
MsgBox "Help"
End Sub

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

Am Fri, 16 Aug 2013 09:59:31 -0700 (PDT) schrieb clay:
This code is placed in the Sheet.
Click to expand...

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


Regards
Claus B.
 
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 :
 
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 :
Click to expand...

Isabelle,

Thank you. That fixes the problem.
 
Back
Top