How to display the update the link window but then suppress any alert messages later?

Hello there,

In Excel, I want to suppress the display of all alert messages, except the very first Ask-To-Update-Links message. How can I achieve this with a VBA macro?

Thank you very much.

Sounds interesting question. I'm also looking for the answer.

Hi venkat1926, thanks for the suggestion. I'm still not sure how to implement it as a macro

Originally Posted by venkat1926

try to introduce

application.displayalerts=false
after the first alert needed

this is offhand suggestion as full data or macro not available