Suppress warning message

G

Garry

I have written a macro in Word VBA using Word 2002. This
macro opens an excel spreadsheet then copies some graphs
into a Word document. However, because the excel file
contains macros, the Word macro halt execution due to a
warning message that the file contains macros and ask if I
want to continue. I would like to suppress this warning
message from within the Word macro such that the macro
will continue to run.

Any and all help would be greatly appreciated

Garry
 
W

Word Heretic

G'day "Garry" <[email protected]>,

try setting

Application.DisplayAlerts=wdAlertsNone

Steve Hudson - Word Heretic

steve from wordheretic.com (Email replies require payment)
Without prejudice


Garry reckoned:
 

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

Macro warning in word 1
Supprressing Warning message from Macro 1
Mail Merge Directory Conditional Page Break 0
Need help modifying code 0
suppress macro messages 1
Suppress warning message 2
Remove Macros from Template 6
Word: Displaying warning messages when certain numbers are typed? 3

Top