Suppressing questions in Excel Macros

  • Thread starter Thread starter danfw
  • Start date Start date
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.
 
Try this. Hope this helps! If so, let me know, click "YES" below.

Application.DisplayAlerts = False

' your code here


Application.DisplayAlerts = True
 
Back
Top