On Mon, 06 Aug 2007 12:50:28 -0000, Ray wrote:

You can suppress that message with:
Application.DisplayAlerts = False
right before the code to Close the workbook.

I'm sure there's a way to check for changes, but I have no idea how to
code for that ...

Ray, I put that into

Private Sub Workbook_BeforeClose(Cancel As Boolean)

but it has no affect there and still brings up the prompt.

Was there where you meant it to go?

Thanks - Kirk