Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to protect cell with formula from being entering info
Can someone advise how can I protect the cell which contain formual and I
know excel had a function to uncolor the cell when result is being calculate. Example Formula in cell A3 with Blue Color == A1 + A2 Result required When I key in no. in A1 & A2, A3 will show the result and blue color is disappeared and A3 do not allow user in anything |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
How to protect cell with formula from being entering info
Hi
Select cell/cell range; Select Format Cells from menu or from drop-down opened by right-click; On Protection tab of Format Cells window set protection options: Locked - cell contents will be protected when selected. Hidden - user will see only results instead of formulas. Nothing is displayed in formula bar when the cell is selected, or in edit mode. Protection setings will work only when the sheet is protected. When the sheet is unprotected, the user can edit any entries without any restrictions. My advice is to select at start the whole sheet, and set main protection options. After that, select ranges where you want different protection options, and reset them. -- Arvi Laanemets ( My real mail address: arvi.laanemets<attarkon.ee ) "TSK" wrote in message ... Can someone advise how can I protect the cell which contain formual and I know excel had a function to uncolor the cell when result is being calculate. Example Formula in cell A3 with Blue Color == A1 + A2 Result required When I key in no. in A1 & A2, A3 will show the result and blue color is disappeared and A3 do not allow user in anything |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
entering info into different worksheets | New Users to Excel | |||
Protect a worksheet, but allow ONLY specific users to change info | Excel Worksheet Functions | |||
How do I protect the cell from users entering values in Excel? | Excel Worksheet Functions | |||
Formula is entering a default time when it comes across an empty cell.. | Excel Worksheet Functions | |||
getting info into a new tab and changes when entering in other tab | Excel Worksheet Functions |