Excel crash when autocalculating locked cell

[Gilbertjoe]

I have a worksheet in Excel 2002 that has 3 cells- Time in, Time out, and hours worked. The hours worked cell calculates from the Time in and Time out cells. I then protected the sheet and locked the hours worked cell. Now Excel crashes after I update the Time out cell. When I unlock the hours worked cell, no crash.
???? Help!

 

[Gilbertjoe]

I think I fixed it myself. I had the cell protection set so that you could not select the locked cell. Once I checked select locked cell, no more crash.