Hi,

Sub your_Other_sub()

application.enableevents=false
'do things
application.enableevents=true

end sub

Mike

"sunilpatel" wrote:

Private Sub Worksheet_Change(ByVal Target As Range)

code....

End Sub

Is there a way of disabling above code temporarly, e.g when a particular sub
is active