
Lock rows of cells based on a date value in one cell
Chrisander A G Ravna
20
Reputation points
I`m looking for a way to lock or freeze a set of rows from getting edited based on a date value in one cell.
In this example I need to freeze the marked rows when the date in the left most cell is one week old. Freeze the rows of cells when its 9. january.
Microsoft 365 and Office | Excel | For business | Windows

3,920 questions
Accepted answer
1 additional answer
Sort by: Most helpful
-
Sukanya Mukherjee 90 Reputation points
2023-07-10T12:21:02.69+00:00 Hi !, You can try it with Excel VBA code
Right now I am trying to resolve , it will take time,
Hope it helps
Thanks