How do I prevent pop-up boxes from coming up while executing the code?

Question

I have a code which copied data between files. Some of these files have links to other files. So, when I run my macro to automatically copy data to other files, I get these pop-ups asking me whether I want to update these links. And after selecting "update", I get another pop-up saying that these links cannot be updated and asking me whether I would like to continue. Even while saving the file after copying, I get a pop-up saying "Be careful...." I do not want these pop-ups to appear while running the code. I want it to be fully automatic i.e. without any manual intervention

Workbooks.Open filename, UpdateLinks:=False) or True

Damian
– Damian

2019-06-26 08:37:29 +00:00
Commented Jun 26, 2019 at 8:37 — Damian
– Damian, Commented Jun 26, 2019 at 8:37

Tim Stack · Accepted Answer · 2019-06-26 08:48:57Z

3

Display messages can easily be avoided like so:

Sub test()
Application.DisplayAlerts = False

'Code

Application.DisplayAlerts = True
End Sub

EDIT
To avoid the Update warning:

Sub test()
Application.AskToUpdateLinks = False
Application.DisplayAlerts = False

'Code

Application.AskToUpdateLinks = True
Application.DisplayAlerts = True
End Sub

And in case you're just opening a workbook, this is sufficient:

Application.Workbooks.Open Filename:="C:\test.xlsx", UpdateLinks:=False

edited Jun 26, 2019 at 8:48

answered Jun 26, 2019 at 8:33

Tim Stack

3,2483 gold badges25 silver badges46 bronze badges

Sign up to request clarification or add additional context in comments.

1 Comment

Rithwik Sarma Over a year ago

Worked well with two pop-ups. Still, get one. See my edit to view the image of the pop-up

Collectives™ on Stack Overflow

How do I prevent pop-up boxes from coming up while executing the code?

1 Answer 1

1 Comment

Your Answer

Hot Network Questions

Collectives™ on Stack Overflow

1 Answer 1

1 Comment

Your Answer

Sign up or log in

Post as a guest

Related