LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 3
Default 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

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Application.DisplayAlerts TK Excel Programming 4 April 7th 05 08:41 PM
Application.Displayalerts = value (is not working for me) [email protected] Excel Programming 3 December 18th 04 02:00 AM
Application.DisplayAlerts in IE scoobydeux Excel Programming 1 April 19th 04 01:28 AM
Application::DisplayAlerts not working Howard Dierking Excel Programming 2 February 11th 04 12:04 PM
application.displayalerts Erin[_5_] Excel Programming 1 December 4th 03 03:49 PM


All times are GMT +1. The time now is 09:20 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"