By using listi.net you agree to our cookie policy, We and our partners operate globally and use cookies, for multiple purposes
listi.net
How to suppress the popup message in Excel?
In VBA programming you can use the following: Application.DisplayAlerts = False ' prevents Excel/vba from displaying a dialog
' ... code here
Application.DisplayAlerts = True ' allows Excel/VBA to display a dialog.
Note that turning DisplayAlerts on could be a problem if called from another part of the code that needs DisplayAlerts to remain off. The following will handle this" Dim bDisplayAlerts As Boolean bDisplayAlerts = Application.DisplayAlerts ' save the value Application.DisplayAlerts = False .......