Application.DisplayAlerts doesn't seem to work

I'm trying to load a custom add-in automatically and the add-in
displays an alert saying that it was loaded and the user must click OK
or press the Enter key for the alert to close. I would like to supress
this alert so that the rest of my macro can finish without user
interaction (this is just one small subroutine in a larger process).
Can anyone explain to me why displayalerts=false doesn't work and what
a workaround might be? I also find that the second macro below
(TestAlerts) has the Hello World message box pop-up, so I'm fairly
confused about what DisplayAlerts actually does.

Is there some other automated way to close alert windows?

Sub LoadAddIn()
AddIns.Add Filename:="C:\abc\addin32.xll"
Application.DisplayAlerts = False
AddIns("ABC32").Installed = True
Application.DisplayAlerts = True
End Sub

Sub TestAlerts()
Application.DisplayAlerts = False
Msgbox "Hello World!"
Application.DisplayAlerts = True
End Sub

I'm using the following:
OS version - Windows (32-bit) NT 5.01
Excel Release - 11.0

Thanks for whatever help you can give!
-Jason

DisplayAlerts suppresses most prompts from the excel application itself (not
the operating system). It does not affect msgboxes generated by code as you
have discovered.

--
Regards,
Tom Ogilvy


"[email protected]" wrote:

> I'm trying to load a custom add-in automatically and the add-in
> displays an alert saying that it was loaded and the user must click OK
> or press the Enter key for the alert to close. I would like to supress
> this alert so that the rest of my macro can finish without user
> interaction (this is just one small subroutine in a larger process).
> Can anyone explain to me why displayalerts=false doesn't work and what
> a workaround might be? I also find that the second macro below
> (TestAlerts) has the Hello World message box pop-up, so I'm fairly
> confused about what DisplayAlerts actually does.
>
> Is there some other automated way to close alert windows?
>
> Sub LoadAddIn()
> AddIns.Add Filename:="C:\abc\addin32.xll"
> Application.DisplayAlerts = False
> AddIns("ABC32").Installed = True
> Application.DisplayAlerts = True
> End Sub
>
> Sub TestAlerts()
> Application.DisplayAlerts = False
> Msgbox "Hello World!"
> Application.DisplayAlerts = True
> End Sub
>
> I'm using the following:
> OS version - Windows (32-bit) NT 5.01
> Excel Release - 11.0
>
> Thanks for whatever help you can give!
> -Jason
>
>

Is there anyway to suppress or respond to a prompt that is tying up
Excel but is not suppressed by DisplayAlerts?
-Jason

Basically no built in way.

--
Regards,
Tom Ogilvy


<[email protected]> wrote in message
news:[email protected]...
> Is there anyway to suppress or respond to a prompt that is tying up
> Excel but is not suppressed by DisplayAlerts?
> -Jason
>

Thanks for your help, Tom!