How does B1 get to be 7. Manual entry? Formula? Macro?

--
Regards,
Tom Ogilvy

"John" wrote in message
...
I want to protect all cells in a workbook if the Contents of cell B1 7.
My
thinking is that if the value of Cell B1 7 then the worksheet should not
be worked on, kind of a security feature

Is there any such code I should use?

Thanks