Thread: change event
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
ranswert ranswert is offline
external usenet poster
 
Posts: 161
Default change event

I have the following code in a worksheet change event:

Private Sub Worksheet_Change(ByVal Target As Range)
On Error GoTo stoppit
Application.EnableEvents = False
enteritem
Application.EnableEvents = True
stoppit:


End Sub

It was working until I made some changes in the 'enteritem' procedure and
now nothing happen. I've put 'msgbox("")' in and nothing happens in this
worksheet or an anyother worksheets. How do I get them to work again?
Thanks