Probably the best way to do this is to put some code in the workbook's
_BeforeClose() event to verify that all required cell entries have been made
and to alert you if they haven't and offer to let you cancel the Close action
so you can complete the workbook.

"Anitha" wrote:

Please let me know how should i get alert message when i close my excel
window if selected cells are empty.