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!

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"
<[email protected]> wrote in
message
news:[email protected]...
>
> 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
>

Fantastic, that's solved it - you're a legend!