Disable pop up warnings in Excel 2000

  • Thread starter Thread starter Raphael
  • Start date Start date
R

Raphael

Hi everyone!

Is it possible to prevent any warnings and/or error
messages pop ups to appear after running a macro?

Could someone send me a command to do it?

Thanks in advance!

Raphael
 
Hi
at the beginning of your macro insert
application.displayalerts = false

and turn them on afterward with
application.displayalerts = true
 
Turn it on or off.

Application.DisplayAlerts = False
Workbooks("BOOK1.XLS").Close
Application.DisplayAlerts = True
 
You must log in or register to reply here.

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

File Download - Security Warning 5
Privacy warning in Excel 2007 1
Excel Pop-up Question 4
Disable Security Warnings Screen 3
Pop up Read Only and Existing User ! 1
Disable Save 5
Auto Close Pop-up MsgBox 4
XL 2007 Macro Security warning 1

Back
Top