ExcelBanter - Turn off all error messages in Excel

ExcelBanter (https://www.excelbanter.com/)

- Excel Programming (https://www.excelbanter.com/excel-programming/)

- - Turn off all error messages in Excel (https://www.excelbanter.com/excel-programming/440957-turn-off-all-error-messages-excel.html)

Igor G.

Turn off all error messages in Excel

How to turn off all error messages in Excel?
I have occasionally problems with broken links to database (pop-up messages).
I try with Application.DisplayAlerts:= False
Thanks!

Mike H

Turn off all error messages in Excel

Hi,

The correct syntax is

Application.DisplayAlerts = False

Note there is no colon
--
Mike

When competing hypotheses are otherwise equal, adopt the hypothesis that
introduces the fewest assumptions while still sufficiently answering the
question.

"Igor G." wrote:

How to turn off all error messages in Excel?
I have occasionally problems with broken links to database (pop-up messages).
I try with Application.DisplayAlerts:= False
Thanks!

All times are GMT +1. The time now is 12:32 AM.