| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Locking cell depending on outcome of formulae
Am hoping that someone has the answer to this. In cell B1 I have a formulae
=If(a1="additional concern","Add Conc","Please Select"). It also has a drop down validation box with other values. I want to be able to lock B1 if the outcome of the formulae is "Add Conc", but leave it unlocked for users to select from the drop down if "Please Select". This spreadsheet will have additional rows inserted at various times, so want this VBA to work for each row as it is inserted and data input. Thanks in anticipation. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Changing the font of a cell dependant on the outcome | Excel Worksheet Functions | |||
| vba outcome | Excel Worksheet Functions | |||
| wrong calculation in excel? formula outcome < cell value?? | Excel Worksheet Functions | |||
| Dynamically locking a cell depending upon value of another cell. | Excel Discussion (Misc queries) | |||
| Excel : Hiding/Locking Formulae | Excel Discussion (Misc queries) | |||
![Janelle S[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Linear Mode
