Lock a cell by current date?

[HUNTXTRM]

Is it possible to lock a cell by the current date? For instance. I want cell A1 to lock itself for editing after tomorrows date? I am trying to force and input by a certain date, if there is no input by that date, then the cell locks. Any Ideas?

[tim201110]

a lot.
but they won't work if a user disabled macros.

[HUNTXTRM]

It could only be done with macro's?

[popipipo]

With Data validation it is also possible

[HUNTXTRM]

I will give that a try. Thanks

[HUNTXTRM]

With Data validation it is also possible

That worked awesome. I modified it a little to suite my needs, but it was on the money. Any idea how to "Conditional Format" a cell to be a certain fill color, if the reference cell is todays date?

Say for instance A2 is "1-Oct_15" Cell A3 is green fill. But only if "1-Oct-15" is todays date?

[perezo]

Hello everybody, i want to ask if is possible to hide worksheet in excel but after making him visible again he will ask me for passsword first. I just dont want lock collums, cells or hide formulas all i need is ask for password before hiden worksheet will be visible again. I look lot of articles but everywhere people talking or solving problem just with locked collums and cells.
Thanks for any help.