View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Ryan H Ryan H is offline
external usenet poster
 
Posts: 489
Default 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.