I have an Excel Workbook with multiple worksheets. I would like to require entry into cells C111:C115 and cell B9 on three of the worksheets (let's call them Tab1, Tab2 and Tab3). If these cells are left blank then the user will not be able to save or print the workbook. Note that cell B9 is a drop down field with Yes/No for a choice and the default is blank. Also note that 0.00 is the value that displays in C111:C115 upon opening the worksheet. These cells track hours worked. I would like it to display 0.00 upon entering so technically I want the value in these cells to be "not blank and >0.00". I also am wondering if this will cause a Catch-22 since B9 will be blank. Will it allow me to save it in the beginning prior to using it with the new rules?

Thank you.