Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Enable/Disable Macro Pop-Up | Excel Discussion (Misc queries) | |||
enable/disable macro | Excel Discussion (Misc queries) | |||
Disable VBA code execution when loading a workbook | Excel Discussion (Misc queries) | |||
Enable/Disable Macro | Excel Programming | |||
macro disable and enable. | Excel Programming |