hello,

I am trying to automate the collation of a monthly report in MS Word, i have added lots of tables and graphs from MS Excel using the paste link option.,

I have the following code:

Application.DisplayAlerts = wdAlertsNone
ActiveDocument.Fields.Update
Application.DisplayAlerts = wdAlertsAll
But i get a message when excel opens asking that i enable the macro's, this occurs for every link.

Is there any way to turn these messages off?

Many Thanks