Check for empty cells on exit

Hi all,

I don't have a lot of experience with vba and I've been twisting my melon over this all morning; help would be really appreciated!

Basically I want to make sure that all the required cells have been completed on closing the work book but theworkbook closes regardless of 'ok' or 'cancel'. I tried unload me instead of Exit Sub but it opens the debugger:

Please Login or Register  to view this content.

Thanks,

Neil

Change this line:

Please Login or Register  to view this content.

To:

Please Login or Register  to view this content.

That should do it.

Thank you so much Andrew, that works perfectly. What a relief!