Wrap your code within the Enableevents eg

Private Sub Worksheet_Change(ByVal Target As Range)
Dim C As Long
C = Target.Column

application.enableevents=false

Select case
Case is =1
Call Macro1
Case is =2
Call Macro2
End Select

application.enableevents=true

End Sub


--
Ivan F Moala


------------------------------------------------------------------------
Ivan F Moala's Profile: http://www.excelforum.com/member.php...fo&userid=1954
View this thread: http://www.excelforum.com/showthread...hreadid=490447