Copy/insert copied cells when protection is on...
Hi
I have a spreadsheet with heaps of large formulas on each row.
I wanted to hide the formulas so users don't see/change/freak about them so
I used protection but ticked on all boxes allowing users to make changes but
not see the formula.
Unfortunately this doesn't seem to allow the user to copy a row and insert
copied cells to copy the formulas to a new row. It only copies and pastes
the result of the formula.
Does anyone know how I can hide formulas but allow users to copy/insert
copied cells?
--
Thank for your help
BeSmart
|