Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hiding formula but allow changes
I created a spreadsheet that I want to share. It allows users to make
calculations and create several different financial forms when adding data on one worksheet. I want users to be able to insert data but not see the formula. If I hide the cell then protect the worksheet you can't change the data. Is this possible? |
#2
|
|||
|
|||
If I understand you correctly you want the users to be able to input values
in cells that are refered to by the formulas but hide the formulas so they cannot see the formulas just the result? If so you can select all cells that you want the users to be able to change/edit, do formatcellsprotection and uncheck locked, then select the formula(s) and do the same but check hidden instead of unchecking locked, then protect the sheet, now you can change the values in the cells you unlocked but they cannot see the formulas only the result regards, Peo Sjoblom "slant55" wrote: I created a spreadsheet that I want to share. It allows users to make calculations and create several different financial forms when adding data on one worksheet. I want users to be able to insert data but not see the formula. If I hide the cell then protect the worksheet you can't change the data. Is this possible? |
#3
|
|||
|
|||
Hi slant55
First, select the cells in which you want users to enter data, then go to Format - Cells - Protection and deselect Lock. Next, select the formulae you want hidden, go to Format - Cells - Protection and select Hidden. Finally, go to Tools - Protection and Protect Sheet. This will allow your users to enter data, but not change or see the formulae. HTH Sincerely, Michael Colvin "slant55" wrote: I created a spreadsheet that I want to share. It allows users to make calculations and create several different financial forms when adding data on one worksheet. I want users to be able to insert data but not see the formula. If I hide the cell then protect the worksheet you can't change the data. Is this possible? |
#4
|
|||
|
|||
"slant55" wrote:
I created a spreadsheet that I want to share. It allows users to make calculations and create several different financial forms when adding data on one worksheet. I want users to be able to insert data but not see the formula. If I hide the cell then protect the worksheet you can't change the data. Is this possible? Well it depends a bit on which version of Excel you have. With Excel 2003, you can stop users from selecting locked cells when the sheet is protected i.e. the cells with formulae in them. By allowing users to select only the unlocked cells into which they enter data, you can achieve your objective. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
put formula results into a different cell if it is empty | Excel Worksheet Functions | |||
how do i write a formula and keep in in formula form, so it DOESN. | Excel Discussion (Misc queries) | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Hiding Formula in cells | Excel Discussion (Misc queries) | |||
Cell doesn't show formula result - it shows formula (CTRL + ' doe. | Excel Worksheet Functions |