Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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. |
#2
|
|||
|
|||
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. |
#3
|
|||
|
|||
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. |
#4
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Stop Excel Rounding Dates | Excel Discussion (Misc queries) | |||
To stop Excel from opening many workbooks at startup | Excel Discussion (Misc queries) | |||
How can I stop Excel from displaying rounded numbers? Credit car. | Excel Discussion (Misc queries) | |||
How do I stop the autopaste function in Excel? | Excel Worksheet Functions | |||
How do I stop automatic page breaks in excel | Excel Worksheet Functions |