Macro for "close w/no save"?

[Jerry C]

In Word, I have created a couple helpful macros and placed
them on the toolbar with an icon. The piggybank will
close the open document and save all changes. The garbage
can will close the document and NOT save any changes.
This precludes me having to respond to the "do you want to
save changes?" prompt each time (annoying!).

They work slick in Word.

Now, I'd like to have the same feature in Excel, but the
macro design or language is different and I can't figure
it out.

Here's the simple one-line of code for the "close no save"
macro (in Word):
ActiveDocument.Close SaveChanges:=wdDoNotSaveChanges

What would be the equivilent in Excel?

Thanks in advance.

Jerry

 

[E_R]

You can turn the alerts off...

Application.DisplayAlerts = False

 

[Guest]

-----Original Message-----
You can turn the alerts off...

Application.DisplayAlerts = False

I'm not sure that will solve it. With the alerts turned
off, what happens if I have a file I've made changes to,
and want to save the changes, and I click the "X" to close
it (without having saved it first)?

What I want to be able to do is to "close and save"
or "close and not save" with one click of the mouse.

Will turning off the alerts do that?

Jerry

 

[Norman Jones]

Hi Jerry,

Try:
ActiveWorkbook.Close SaveChanges:=False

 

[Jerry]

I've been working with it and I think I have it figured
out now.

Jerry

 

[E_R]

You only put that code in the Garbage Can functio

 

[E_R]

whoops, didn't finish my point... something like this

Application.DisplayAlerts = False
ActiveWorkbook.Close
Application.DisplayAlerts = Tru

 

[Tom Ogilvy]

It is the same as word
Activeworkbook.Close SaveChanges:=False

ActiveWorkbook.Close SaveChanges:=True