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

disable and enable macro execution using VBA in another workbook?
 

Hi Keith,

Try wrapping the problematic instruction with EnableEvents statements,
e'g.:

Application.enableEvents = False 'Disable events

'code line(s)


Application.EnableEvents = True 're-enable events


---
Regards,
Norman



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