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
|