It shouldn't be re-locking if they select Tardy & the field is blank.
We put the "Exit Sub" command in the If...Then... statement so it would
exit the macro and not re-lock. If it is re-locking, then resend the
book to me and I will look at the code. I don't have the book with me
to check the coding.


--
dok112
------------------------------------------------------------------------
dok112's Profile: http://www.excelforum.com/member.php...o&userid=10581
View this thread: http://www.excelforum.com/showthread...hreadid=513772