View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
akemeny akemeny is offline
external usenet poster
 
Posts: 63
Default Help with Debug issue

I have my macro set and everything works perfectly, but the Debug goes off
every so often and always at the same line. Can anyone please look at the
macro below and tell me where I need to make a change to stop the debugger??

Private Sub Worksheet_Change(ByVal Target As Range)
With Worksheets("June 13 - 2045875") <------------This is where the
Debug hits
Application.EnableEvents = False
Call Sheet10.colortotalrow
Application.EnableEvents = True
End With
End Sub