three ways at least to do this:
(1)
Workbooks(SomeWorkbook).Close False
' false sats don't save

(2)
Application.DisplayAlerts = False
Workbooks(SomeWorkbook).Close
Application.DisplayAlerts = True

(3)
Workbooks(SomeWorkbook).Saved = True
Workbooks(SomeWorkbook).Close


Patrick Molloy
Microsoft Excel MVP

-----Original Message-----
Excel 2000
Windows 2k Pro

I was hoping I could put some code in the Workbook_Close
event handler that
would suppress any save prompts. Can this be done, and
if so, how?

TIA

-gk-


.

-----Original Message-----
Excel 2000
Windows 2k Pro

I was hoping I could put some code in the Workbook_Close
event handler that
would suppress any save prompts. Can this be done, and
if so, how?

TIA

-gk-


.