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