Hiding formula but allow changes

S

slant55

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?
 
P

Peo Sjoblom

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 format>cells>protection 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
 
M

Michael

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
 
B

bigwheel

slant55 said:
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?
Click to expand...

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.
 
Top