Annoying Error Message

[peteypie76]

Hi.

I run a spreadsheet that is dependent upon the live date. I have set up a data connection to a time server website. Unfortunately the location of the some of the screens displaying the spreadsheet occasionally drop the internet connection. This means that when the data connection runs the query (every minute) then it gets the error below. Once we clock ok and the internet wifi is restored then it will automatically refresh. Because it halts I have to get a technical team member to remote into it to click ok on every screen. It is a waste of time. If we could suppress the error then it would just work.

I cannot find a way on the menus to disable / suppress the error message. Does anyone know a way please?

Thanks

 

[James006]

Hi,

Have you tested

Application.DisplayAlerts = False

 

[chaddres]

Note: this will turn off all alerts, not just the one you asked about.

Sub Macro1()

    Application.DisplayAlerts = False

End Sub

 

[Skyybot]

Hi.

I run a spreadsheet that is dependent upon the live date. I have set up a data connection to a time server website. Unfortunately the location of the some of the screens displaying the spreadsheet occasionally drop the internet connection. This means that when the data connection runs the query (every minute) then it gets the error below. Once we clock ok and the internet wifi is restored then it will automatically refresh. Because it halts I have to get a technical team member to remote into it to click ok on every screen. It is a waste of time. If we could suppress the error then it would just work.

I cannot find a way on the menus to disable / suppress the error message. Does anyone know a way please?

View attachment 86509

Thanks

Did any of the replies work?

 

[peteypie76]

Hi,

I added the line Application.DisplayAlerts = False to the window and it didn't work. I'm going tot try adding the following to the sheet.

 

[peteypie76]

Sub Macro1()

Application.DisplayAlerts = False

End Sub