Hi Excel masters,
I want to restrict cell editing if the date is not "today".
Meaning - I have a table like this:
![](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2FkWQRLm%2Ftest.jpg&hash=19a015abb5d6d2de1860685d68078e12)
And I would like to restrict access to cells so they can only fill the cells of todays date (each date has 3 rows), so they can't edit yesterdays inputs, or make inputs ahead for tomorrow.
Can it be done?
Thanks
I want to restrict cell editing if the date is not "today".
Meaning - I have a table like this:
![](/board/proxy.php?image=https%3A%2F%2Fpreview.ibb.co%2FkWQRLm%2Ftest.jpg&hash=19a015abb5d6d2de1860685d68078e12)
And I would like to restrict access to cells so they can only fill the cells of todays date (each date has 3 rows), so they can't edit yesterdays inputs, or make inputs ahead for tomorrow.
Can it be done?
![Smile :) :)](https://cdn.jsdelivr.net/joypixels/assets/8.0/png/unicode/64/1f642.png)
Thanks