disabling Excel pop-up dialog boxes

[Guest]

I'd like to know how to close a spreadsheet unconditionally without incurring
a saving dialog popup box (that requires operator input). I believe it can
be done using VB, and I'd like to know how to do this; if there is a way to
manually configure Excel when I first open Excel (2003), this may also work.
Thanks.

 

[Jim Rech]

There is no setting in Excel for this. The only approach I can think of is
to set an application level event handler (in an add-in I think) that
intercepts the Before_Close event of all workbooks and sets their Saved
property to True. Chip Pearson has a page describing application event
handlers:

http://www.cpearson.com/excel/AppEvent.htm

--
Jim Rech
Excel MVP
| I'd like to know how to close a spreadsheet unconditionally without
incurring
| a saving dialog popup box (that requires operator input). I believe it
can
| be done using VB, and I'd like to know how to do this; if there is a way
to
| manually configure Excel when I first open Excel (2003), this may also
work.
| Thanks.

 

[Guest]

Try:

Application.Quit
Application.ActiveWorkbook.Close savechanges:=False

HTH,
Gary Brown