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

Private Sub Worksheet_Activate()
MsgBox "Help"
End Sub

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

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

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.
--
Win XP PRof SP2 / Vista Ultimate SP2
Office 2003 SP2 /2007 Ultimate SP2

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

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 :
Private Sub Worksheet_Activate()
MsgBox "Help"
End Sub

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

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

On Friday, August 16, 2013 12:29:15 PM UTC-5, isabelle wrote:
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 :

Private Sub Worksheet_Activate()

MsgBox "Help"

End Sub



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



Isabelle,

Thank you. That fixes the problem.