View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.programming
isabelle isabelle is offline
external usenet poster
 
Posts: 587
Default 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.