Display Alerts

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Hi all

I've heard that putting 'Application.DisplayAlerts = False' stops the
ActiveX warning pop-up when the workbook is opened, however when I run my
code it won't actually change the alerts to false, what could be wrong here?

Thanks in Advance

Jason
 
The Display alerts is designed to stop the kind of alerts you get when, for
example, you try to save a file with a name of an existing file, or when you
delete a worksheet - this is so that code can run "automatically" without
stopping for user input.
The ActiveX warning is at application level - ie the O/S raises it rather
than Excel itself. If you Google for it, you'll see that you can set a
Registry item that stops the warning.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

XL03: Avoid "workbook contains links" msg when opening 5
Disable Alert 5
display alerts= false not working 2
Changing default response of an alert through vba 1
Display Alerts 4
Suppress warning message 2
Application.DisplayAlerts = False 10
Application.DisplayAlerts doesn't seem to work 4

Back
Top