That means that you already have a Worksheet_Change event procedure, so you
need to amalgamate them.

--
__________________________________
HTH

Bob

"NoodNutt" wrote in message
...
Bob

Sorry to be a pest.

Seems I can't use this code.

Keep getting Compile Error: Ambiguous Name Detected (Worksheet_Change)

I'm fairly certain it has to do with the DateTime picker:
Private Sub Worksheet_Change(ByVal Target As Range)
If Not Intersect(Target, Range("G5:G2004")) Is Nothing Then
If DTPicker1.Visible Then DTPicker1.Visible = False
End If
End Sub

Any thoughts.
Mark.