Suppressing questions in Excel Macros

D

danfw

How does one suppress dialog that appears when executing a macro in Excel
2003. For example, a question such as "Do You Want To Save...". I have
tried statements such as Application.CommandBar.... and Workbook.Command... ,
but they don't work.
 
R

Ryan H

Try this. Hope this helps! If so, let me know, click "YES" below.

Application.DisplayAlerts = False

' your code here


Application.DisplayAlerts = True
 

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

Macro warning in word 1
Need Help with Macro Security 1
Suppressing "Do you want to save" message when closing the slideshow 0
Show customUI when I launch the contextMenu from a VBA macro 0
Trying again for an answer. 3
Pop up message asks if I really want to edit the live office data 2
Suppress warning message 2
XML Suppress Keytip Auto-Assignment in Custom Ribbon Tab 0

Top