Close Active Sheet Without Closing

[ISUSA]

There is probably an easy solution for this, but I can't find it.

Here is my issue:

I'm doing a simple copy/paste between two files. I am copying from file B and pasting to File A. I'm compiling several cells into file B before copying over to file A and this changes file B. When I do an activate close on File B, I always get the window that asks if I want to save changes. I don't want this box to pop up and to just shut the sheet without saving. I can't figure out what the code is to accomplish this.

[Olly]

Please Login or Register  to view this content.

[alansidman]

Or another way

Please Login or Register  to view this content.

[ISUSA]

PERFECT!!!! Thank you all for your help. Case closed.