Disable macro at runtime
 

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

Disable macro at runtime
 

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" wrote in message
...
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

Disable macro at runtime
 

Perfect thank you
Sandy

"Bob Phillips" wrote in message
...
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" wrote in message
...
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