Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Application.DisplayAlerts | Excel Programming | |||
Application.Displayalerts = value (is not working for me) | Excel Programming | |||
Application.DisplayAlerts in IE | Excel Programming | |||
Application::DisplayAlerts not working | Excel Programming | |||
application.displayalerts | Excel Programming |