Dave

In addition to John's response, there is also a SaveChanges argument to the
Close method of the Workbook object that will avoid the prompt.

--
Dick Kusleika
MVP - Excel
www.dicks-clicks.com
Post all replies to the newsgroup.

"David Ralph" wrote in message
...
Hi,

I'm trying to get Excel to exit without prompting the user to save the
workbook.

I have aready constructed the IF statement using a MSGBOX, but when you
choose the NO
option the Excel then prompts you if you wish to save the workbook before
exiting.

Is there some way of turning off Excels messaging, so it just exits?


Cheers

Dave