| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Conditionally lock a Cell
I have a holiday sheet where a number of the cells are locked but some can be
accessed to put in holiday requests. The person inputs their holiday request in cell C15, the manager then unlocks the worksheet and puts "Yes" into cell G15. Is there anything I can do to make this "Yes" entry automatically tick the lock cell option in C15 - so that the request cannot be retrospectively changed once the approval has been made? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| I have lock a wookbook but one cell does not want to lock it | Excel Discussion (Misc queries) | |||
| Lock cell control conditionally? | Excel Discussion (Misc queries) | |||
| How can you lock cell conditionally | Excel Discussion (Misc queries) | |||
| conditionally lock cells? | Excel Discussion (Misc queries) | |||
| Lock and unlock cells conditionally depending on input in another | Excel Worksheet Functions | |||
Threaded Mode
