ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Application.DisplayAlerts not working (https://www.excelbanter.com/excel-programming/377353-re-application-displayalerts-not-working.html)

NickHK

Application.DisplayAlerts not working
 
Well, Application.DisplayAlerts does work, but without any code it's
impossible to advise.

NickHK

"ProCon" wrote in message
...
I used it in a very simple situation, creating histogram data to overwrite
the previous calculation. My problem is that when I am debugging and I put
the cursor on the line:
Application.DisplayAlerts = False
It remains 'True' even after the line has been actioned.
Code that used to work, when auto-saving files, is now also failing.

"NickHK" wrote:

Application.DisplayAlerts = False does not prevent Excel from showing

all
dialogs, only those that it can safely/logically use a default value

for.
Maybe you are expecting the impossible.

Show that section of code.

NickHK

"ProCon" wrote in message
...
I have used this function many times but it has suddenly stopped

working.
When I run in debug mode the line:
Application.DisplayAlerts = False
has no effect, the value remains True and I get the display I am

trying to
avoid.

Has any one else encountered ths problem?








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

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com