Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Word Document_Open from running
When opening a Word doc from Excel VBA, I want to prevent the Document_Open
routine in the Word doc from automatically running. Application.EnableEvents = False in Excel doesn't stop the Word macro from running - and there seems to be no equivalent command in Word. Putting wdDoc.UserControl = False/True in the Word macro doesn't seem to make any difference - the macro still runs. Any tips? |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Prevent Word Document_Open from running
This may be a long shot, but you if you know the sequence of keys to hold
down when opening word that prevents the code from running, you could try the sendkeys command in excel VBA. "Rich" wrote: When opening a Word doc from Excel VBA, I want to prevent the Document_Open routine in the Word doc from automatically running. Application.EnableEvents = False in Excel doesn't stop the Word macro from running - and there seems to be no equivalent command in Word. Putting wdDoc.UserControl = False/True in the Word macro doesn't seem to make any difference - the macro still runs. Any tips? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Prevent code running | Excel Programming | |||
How to prevent vba code from running? | Excel Programming | |||
How do I prevent unintentionally running a Macro? | Excel Programming | |||
Prevent others from running my macros | Excel Programming | |||
How to prevent routine from running on certain sheets | Excel Programming |