Hello
I want to make some cells of my spreadsheet adjustable for viewers,
When the viewer enters a number in one of the cells a formula needs to work and give a answer but they shouldn’t be able to adjust the formula cell but i don’t know how to configure it that way…
Jaap
Sorry for the spam didn’t know how i did that
Hi,
So you want to deny user to edit formula, but enable to edit some numeric values?
Unfortunately there is no way to do this, you may just use lock/unlock cell, but it just prevents occasional changing cell value (user can unlock cell and then edit it).