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

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

"Jamie" wrote in message
...
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.

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" wrote:

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

"Jamie" wrote in message
...
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, 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

"Jamie" wrote in message
...
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" wrote:

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

"Jamie" wrote in message
...
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.