hi all
I'm having trouble trying to figure out how to Protect Range from change After specific Date
I have 2 Ranges
First one : Sheets("Sheet1").Range("B2:B10,F2:F10") with data
the second : Sheets("Sheet1").Range("C2:C10,G2:G106") with date
my request is : Protect each cel in Range("B2:B10") based on date in Range("C2:C10")
Protect each cel in Range("F2:F10") based on date in Range("G2:G10")
eg : if the date which in C2 < today Date then Protect B2 from change
if the date which in C3 < today Date then Protect B3 from change
and so on
if the date which in C2 >= today Date then unProtect B2 from change
if the date which in C3 >= today Date then unProtect B3 from change
and so on
note : the protection must be on Range("B2:B10,F2:F10") not others
Can anyone help me with it please??
thanks in advance
Bookmarks