I'm trying to figure out how to accomplish the following:
- Protect the sheet
- Iterate through each row
- If Column 1 contains a date that is > 7 days before the current date then
-
- unprotect column 3, 4, 5, 6 (within that row)
-
- Otherwise do nothing
I've reworked some other examples I found online, but I've been far from successful.