Okay, I don't know what our options are here, but I have a possibly odd question:
I'm looking for a code that, upon the closing of the workbook, checks to see whether all the cells in Batch 1 contain data. If they all don't, then the workbook can be closed without further ado, but if they all do, then it should check to see if all the cells in Batch 2 contain data. If they all do, then the workbook can be closed, but if any of them don't, a message should pop up saying 'Hold it, you ain't goin' nowhere until you put some data in all those cells over there first.'
This is Batch 1:
Cells C2-C6
Cells C8-C13
Cells F6-F14
This is Batch 2:
A18-A22
Any thoughts?![]()
Bookmarks