Cell data required upon close

[pjhageman]

User opens a workbook/worksheet with a cell (merged cells, A1:A6) blank
What code would I use to prevent the user from exiting the workshee
with the cell blank? A close without saving would be legal.

I am using data validation to insure entered values are >

 

[Don Guillett]

Have a look in ThisWorkbook module for before_close

 

[pjhageman]

Don, Thanks for your reply, but I don't understand it. Phil