Exiting a workbook
 

David,

Application.DisplayAlerts = True
should do it.

Another way would be to fool the workbook into thinking
it's already saved.
ThisWorkbook.Saved = True
just before the "close" should work.

John

David Ralph wrote:

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