Close workbook without saving after msg box

Hi,

I have the following code which runs when the user tries to close my workbook

HTML Code: 

I would like the workbook to also close without saving as I don't want users to keep a copy and I don't want them to have another prompt box.

Can anybody assist me to add the following code to the code I have above as I am having problems getting it to work.

HTML Code: 

Thank you very much in advance

:-)

Hi John, thanks very much for your reply.

This is similar to one of the options I had tried but it seems to cause excel to lock up and I have to start the task manager and quit it to shut it down.

I presume it is getting trapped in a loop somewhere or something similar ?????

What do you think?

I want to be able to code it so that if a user clicks no on my message box nothing will happen but if they click yes the application closes without any prompting about saving the workbook.

I hope that makes sense!

:-)

Worked perfectly!!!!!!

Thank you so much for your help

:-) :-)