| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Lock a cell when a given cell contains data
I need to lock cell B1, for instance, when A1 contains data, an
vice-versa. I only want a user to have the ability to populate one o the two fields so that I can write a simple sum formula. Thanks in advance for the help -- Message posted from http://www.ExcelForum.com |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| data validation - cell lock | Excel Discussion (Misc queries) | |||
| Lock out data entry in a cell | Excel Discussion (Misc queries) | |||
| Lock the cell once enter the data | Excel Worksheet Functions | |||
| Lock data in a cell a specific cell based on selection on other ce | Excel Worksheet Functions | |||
| lock one cell when data in another | Excel Programming | |||
Threaded Mode
