disable and enable macro execution using VBA in another workbook?

K

keithb

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
 
N

Norman Jones

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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Copy Autofilter Source Workbook A result in Destination Workbook BSheet1 1
Replacing VBA code strings by using VBA code? 1
Help !! - Create files using VBA code 2
Running macro in another workbook 1
Disable Macro Alert 2
run macro in another workbook - error 1004 7
To Enable Macro in Excel. 2
Programmaticlly sign and password protect a VBA Project in Excel 2 6

Top