Is it possible to protect (lock) specific range cells that contain color highlighted by Conditional Formatting.
These cells are variable.
It works from the dates in the calendar month.
When the year changes, the marked dates (weekends) also change automatically.
I want all cells belonging to the weekend and holiday dates to be locked automatically.
Please see attached example.
Is there any VBA code to solve this problem (or another way)?
These cells are variable.
It works from the dates in the calendar month.
When the year changes, the marked dates (weekends) also change automatically.
I want all cells belonging to the weekend and holiday dates to be locked automatically.
Please see attached example.
Is there any VBA code to solve this problem (or another way)?