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?

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" <(E-Mail Removed)> wrote in message
news:9C144AE9-E17F-4FB1-8072-(E-Mail Removed)...
> 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?

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" <(E-Mail Removed)> wrote in message
> news:9C144AE9-E17F-4FB1-8072-(E-Mail Removed)...
> > 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?
>
>
>

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

NickHK

"ProCon" <(E-Mail Removed)> wrote in message
news:BCDA044E-5A95-4043-B021-(E-Mail Removed)...
> 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" <(E-Mail Removed)> wrote in message
> > news:9C144AE9-E17F-4FB1-8072-(E-Mail Removed)...
> > > 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?
> >
> >
> >