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
|