View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Sandy Sandy is offline
external usenet poster
 
Posts: 270
Default 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