| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Need to lock data based on '=today()' value
I have no idea how to program in vb and I feel that the learning curve is
quite big. Thanks for your help. For every sheet there is a cell that has A1=today() Each column from B9 to BB9 has a date field B9=10/15{date} and C9=(B9+7) and so on. I need to lock the cells in each column under the respective date (listed in B) if it is less than A1.(today) Hope it is a clear explanation. If not please let me know. Thanks again. D Patel |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Dynamic source data based on Today | Charts and Charting in Excel | |||
| Countifs of prior years monthly data based on MTD today | Excel Worksheet Functions | |||
| SUM based on Date < TODAY() | Excel Discussion (Misc queries) | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
| How can I lock a date that has been established by the 'today ()'. | Excel Discussion (Misc queries) | |||
![D Patel[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Threaded Mode
