Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]() Hi, For the active worksheet.... I need to do the following if possible.... If cells F10:F51 have "E" entered, then I need the corresponding cells in G10:G51 to become protected or not allow anything to be entered into those cells. For Example: If a user enterted "E" in F20, then G20 would not allow the user to entered anything into it.. The sheet is already protected...and G10:G51 are not protected cells... I'm not sure if this is possible...but if it is.. I 'm guessing it would have to be done thru code. Any help would be greatly appreciated.. Thanks in advance, Kimberly |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Return cell address of a cell based on contents of cell. | Excel Worksheet Functions | |||
Inputting cell value from source cell based on value in adjacent cell. | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
Cell Formula reference to cell Based On third Cell Content | Excel Discussion (Misc queries) | |||
data validation to restrict input in cell based on value of cell above that cell | Excel Programming |