ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Can I lock cell contents after current date is past? (https://www.excelbanter.com/excel-worksheet-functions/65485-can-i-lock-cell-contents-after-current-date-past.html)

Excel User Greg

Can I lock cell contents after current date is past?
 
I'd like to set up an electronic logsheet in Excel & want to ensure that
users enter in data for a given date only during that actual date (to prevent
"post-dating" the log entries.) Perhaps one way is to lock a cell or a range
of cells if TODAY'S DATE DATE specified in another cell or range of cells?
Just don't know how to do that.


All times are GMT +1. The time now is 09:28 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com