I am looking for a way to have a file run a macro when it is being closed
(the user either hits the X or goes File > Close). I want the macro to check
certain cells and verify if there are values in them. If the cells are blank
then I want an message box to come up saying that all cells are not filled in
and the file remains open. Any help in this area is appreciated. Thanks

Dan