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?