VBA How to disable the following dialogs when running a macro

[Palucci]

Guys !

When I run the macro, I have this message at the beginning.

This workbook contains links to other external data sources that may be dangerous, if you trust them, update them to get the latest data. Otherwise, you can also keep working with the current data.
do not update

I would like this answer to be marked automatically for me " Do not updated " i think its related to Update links.
And second one, i would like always select No. Is there some chance of setting this up

There is a lot of information in the clipboard. Do you want to be able to paste this information into another program later

 

[DanteAmor]

Add these lines to the start of your macro

  Application.ThisWorkbook.UpdateLinks = xlUpdateLinksNever '2
  Application.DisplayAlerts = False

 

[DanteAmor]

There is a lot of information in the clipboard.

If that happens when you close the book, then put the following in the ThisWorkbook events

Private Sub Workbook_BeforeClose(Cancel As Boolean)
  Application.CutCopyMode = False
End Sub