View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
keithb keithb is offline
external usenet poster
 
Posts: 44
Default disable and enable macro execution using VBA in another workbook?

Workbook A.xls has a Worksheet_Change() subroutine that is unintentionally
executed when cell content is modified by VBA code in Workbook B.xls.

Using VBA code executing in Workbook B.xls, I would like to:
1) disable macro exection for workbook A.xls while its content is being
manipulated by VBA code in Workbook B.xls;
2) re-enable macro exection for workbook A.xls prior to saving it.

Any suggestions?

Thanks,

Keith