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

[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.

 

[Paul B]

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

 

[Guest]

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.

 

[Paul B]

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