VBA: close a workbook and DON'T save changes

[istril]

I have a working macro that opens a workbook, does some stuff, and then closes it. But, when I run the macro, it prompts me as to whether or not I want to save changes. Is there a way I can write into the macro not to save the changes?

Currently the code I'm using to close the workbook is the following:

Windows("MTAP.xls").Activate
ActiveWindow.Close

If you know better code, and also a way to tell it not to save changes, I'd be very appreciative!

 

[jindon]

change to

Workbooks("MTAP.xls").Close False

 

[istril]

Thanks jindon!

I am encountering one other problem with this macro though, and was wondering if you or someone else could help:

Range("tempchart!A2:F97").Copy
Sheets("Master").Unprotect
Range("Master!A2:F97").Insert Shift:=xlDown
Sheets("Master").Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

Doesn't work. I'm trying to just copy a range of cells onto a protected sheet. When the macro runs, it inserts the specified cells, but not the values I copied along with it. Any idea why?

 

[jindon]

Because unprotecting worksheet after copy will empty clipboard.
Change the order...

Sheets("Master").Unprotect
Range("tempchart!A2:F97").Copy
Range("Master!A2:F97").Insert Shift:=xlDown
Sheets("Master").Protect DrawingObjects:=True, Contents:=True, Scenarios:=True

 

[istril]

Thanks!