Suppressing questions in Excel Macros
 

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.

Suppressing questions in Excel Macros
 

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

Application.DisplayAlerts = False

' your code here


Application.DisplayAlerts = True
--
Cheers,
Ryan


"danfw" wrote:

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.