| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How can I edit a protected cell to enter a value manually and thenprotect it again (automatically)
I need some help with protected cells. I have many cells with
formulas. All of them are protected. However, sometimes I cannot accept the value calculated by the formula and in such cases, I need to enter the value manually. To do this, I want to edit the cell by using a password. Different users will be entering the value manually so if possible I would like to have a recording system of the user name. Also after the value is entered, the cell should be protected again. Is this too ambitious? I would really appreciate a prompt response on this matter. Thanking in advance. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Protected document loses all protection(hidden columns) when manually copy-pasted | Excel Discussion (Misc queries) | |||
| protected document loses all protection(hidden columns) when manually copy-pasted | Excel Worksheet Functions | |||
| Tab/Enter key moves to next available cell in protected worksheet | Excel Worksheet Functions | |||
| Edit cell automatically takes you to cell | Excel Worksheet Functions | |||
| How do i enter a note in excel to an unlocked cell on a protected. | Excel Discussion (Misc queries) | |||
Threaded Mode
