![]() |
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