View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
gig gig is offline
external usenet poster
 
Posts: 9
Default worksheet change event doesn't work

I have the following simple code for example reasons. For some reason,
when the range "attn" is changed, the macro won't operate.

Here is the simple code I have:

Private Sub Worksheet_Change(ByVal attn As Excel.Range)

Application.EnableEvents = False

MsgBox "hello"


Application.EnableEvents = True

End Sub

There is code to be inserted where the msgbox is. Any suggestions are
greatly appreciated.

Thank you,
Greg