How to skip Worksheet_Change?

[alee001]

Can I skip/disable a sub code before run my marco then recover it like as following:

Private Sub progress()
Skip run/disable Sub Worksheet_Change(ByVal Target As Range)
My Marco
Recover/enable Sub Worksheet_Change(ByVal Target As Range)
End Sub

 

[Logit]

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)


    My Macro


    'Rest of Worksheet_Change macro code here


End Sub

 

[alee001]

Option Explicit


Private Sub Worksheet_Change(ByVal Target As Range)


    My Macro


    'Rest of Worksheet_Change macro code here


End Sub

You may be misunderstanding, I want to skip/disable the Worksheet_Change() tempoary during run Sub progress().

Private Sub Worksheet_Change(ByVal Target As Range)
...other code
End Sub

Private Sub progress()
'skip/disabe Worksheet_Change()
...my marco
'recover/enable Worksheet_Change()
End Sub

 

[Norie]

You can enable/disable events using EnableEvents.

' disable events
Application.EnableEvents = False

' your code/macro
MyMacro

' enable events
Application.EnableEvents = True

 

[alee001]

It's that simple, Thank you.