ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Conditional unlock for cells (https://www.excelbanter.com/excel-worksheet-functions/253836-conditional-unlock-cells.html)

Selva

Conditional unlock for cells
 
Hi,

I need some assistance in unlocking a range of cells based on date
conditions

For example, B1:B32 has dates for the month and based on today's date,
it should unlock the entire column to allow the user to enter the
data.

It should not allow the user to enter data for yesterday or
tomorrow.......

Cell should be open only for today's date.


All times are GMT +1. The time now is 10:36 PM.

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