Excel asking if I want to save changes! It shouldn't

[christhedonstar]

I have this code in a routine

ThisWorkbook.Close SaveChanges:=False

When I call that routine I'm asked if I want to save changes. Why am I asked when I specifically say don't save changes?
How do I prevent this from happening?

Application.displayalerts could help, but then that would disable it for other workbooks open in the excel session which I have no control over.

Any ideas?

Thanks a lot,

Chris

 

[Andrzejek]

What about:

Application.displayalerts = [blue]False[/blue]
ThisWorkbook.Close SaveChanges:=False
Application.displayalerts = [blue]True[/blue]

Have fun.

---- Andy

 

[xlbo]

Do you have anything in the "Before_Save" event or the calculation event that could be being triggered during the close process?

I only ask because the code you have should be fine - just to discount any syntax errors, what happens if you use:

Thisworkbook.close (false)

?

Rgds, Geoff

We could learn a lot from crayons. Some are sharp, some are pretty and some are dull. Some have weird names and all are different colours but they all live in the same box.

Please read FAQ222-2244 before you ask a question

 

[christhedonstar]

Xlbo is right - someone had put some code there and it didn't click with me. Cheers, Chris.

 

[combo]

You can also try:

ThisWorkbook.Saved = True
ThisWorkbook.Close

combo