Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop "save changes" message appearing
During a macro, I close a workbook, but get the "do you want to save changes" message appearing, even though I only opened said workbook purely to copy some cells to another workbook. I didn't -make- any changes! It is crucial that the macro does not halt so that the "save changes" message appears, so how do I stop it happening??? Thanks! -- DJ Dusty ------------------------------------------------------------------------ DJ Dusty's Profile: http://www.excelforum.com/member.php...o&userid=16335 View this thread: http://www.excelforum.com/showthread...hreadid=520084 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop "save changes" message appearing
Some functions like NOW will cause the workbook to calculate on
opening, and thus your workbook will be changed. To close the workbook without saving changes, use Workbooks("Whatever.xls").Close savechanges:=False -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com "DJ Dusty" wrote in message ... During a macro, I close a workbook, but get the "do you want to save changes" message appearing, even though I only opened said workbook purely to copy some cells to another workbook. I didn't -make- any changes! It is crucial that the macro does not halt so that the "save changes" message appears, so how do I stop it happening??? Thanks! -- DJ Dusty ------------------------------------------------------------------------ DJ Dusty's Profile: http://www.excelforum.com/member.php...o&userid=16335 View this thread: http://www.excelforum.com/showthread...hreadid=520084 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Stop "save changes" message appearing
Fantastic, that's solved it - you're a legend -- DJ Dust ----------------------------------------------------------------------- DJ Dusty's Profile: http://www.excelforum.com/member.php...fo&userid=1633 View this thread: http://www.excelforum.com/showthread.php?threadid=52008 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
stop error message "too many different cell formats" | Excel Worksheet Functions | |||
"Save" and "Save As" options greyed out - "Save as Webpage" option | Excel Discussion (Misc queries) | |||
Stop users from accessing "Protection" option from "Tools" menu | Excel Programming | |||
erroneous "save changes?" message appears | Excel Programming |