How do I stop excel from asking me if I want to save my document?

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

Every time I close an excel document, it asks me if I want to save changes
even when I have made no changes at all. How do I stop it from asking me to
save changes? This really screws up my macros when I'm copying from other
sheets as it'll ask after every sheet for me to save.
 
Jamie, to keep excel from showing alerts when you run a macro use something
like this

Application.DisplayAlerts = False
'Your Code
Application.DisplayAlerts = True

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
This works when I run a macro but if I just "file - exit" a document I
haven't made any changes to, it still asks me to save the file. I am using
Excel 2002.
 
Jamie, Some functions in excel are "volatile" sounds like you have some,
have a look here for a list of them

http://www.decisionmodels.com/calcsecretsi.htm

--
Paul B
Always backup your data before trying something new
Please post any response to the newsgroups so others can benefit from it
Feedback on answers is always appreciated!
Using Excel 2002 & 2003
 
Back
Top