Hi,

I need something very similar. I need to interagate cells D8 through D69
and if there is an X in one of those cells then I need to unlock the cell in
column E so if D8 has an X then I need to unlock E8, if D9 has an X then I
need to unlock E9 etc. I am not sure how to find the response you noted
below. I am working very trial and error at adding bits of VBA code to my
spreadsheets to make them more user friendly. Thank you for your help.

"Bob Phillips" wrote:

You have a response in VBAExpress.!

--
__________________________________
HTH

Bob

"Evil Red Smurf" <Evil Red wrote in message
...
Hi,
I'm trying to lock cells in a column on an excel spreadsheet depending on
the (date) value in another cell on the same row. For example, I'm
thinking
of it like this:
If range("C9").value today()
Then range("G9").lock = false
Else range("G9").lock = true
End if

However I want to do it for all rows between 9 and 400 whenever the sheet
is
accessed. Can anyone help?

Many thanks,