View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Ben Ben is offline
external usenet poster
 
Posts: 509
Default suppress Excel save message

Hi all,

I have quick, how do I suppress Exce's save file message box right before I
close the workbook? I tried to put the application.displayalert = false in
the workbook's BeforeClose event, but that does not appear to work. Please
share your thoughts. Thanks in advance.

Ben