Hi Tom

It will be a formula based on =(NOW())-A1, so if the user tries to work on
the form after 7 days, they wouldn't be allowed to. A1 will change based on
external data every week


"Tom Ogilvy" wrote in message
...
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