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


" 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


wrote in message
ups.com...
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!