Disable macro at runtime

[Sandy]

How do you disable a macro from within another macro eg

Sub Sample_Data()

disable macro - "Private Sub Worksheet_Change(ByVal Target As Excel.Range)"

macro "Sample_Data" does its thing

enable - "Private Sub Worksheet_Change(ByVal Target As Excel.Range)"

End Sub

Thanks
Sandy

 

[Bob Phillips]

Sub Sample_Data()

Application.EnableEvents = False

macro "Sample_Data" does its thing

Application.EnableEvents = True

End Sub


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[Sandy]

Perfect thank you
Sandy

Sub Sample_Data()

Application.EnableEvents = False

macro "Sample_Data" does its thing

Application.EnableEvents = True

End Sub


--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)