Thread: Why does Excel ask me to save changes?
View Single Post
  #6   Report Post  
Posted to microsoft.public.excel.programming
jhr_2005 jhr_2005 is offline
external usenet poster
  
Posts: 1
Default Why does Excel ask me to save changes?
It worked for me. Thanks, this is just what I needed.

"Jim Rech" wrote:

Can I in any way persuade Excel that it does not have to prompt

This should do it:

ActiveWorkbook.Saved = True

--
Jim



Reply With QuoteReply With Quote