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

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" <[email protected]> wrote in message
news:[email protected]...
> 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
>