Copy formula from above cell in protected worksheet
 

Hello

On a certain worksheet, the "lock" option from the cell protection (format
cells) has not been selected, but the "hidden" is selected and the sheet has
then been protected.

I am trying to copy the formula from the above cell (from the hidden cell)
to the cell below, but it just copies the text (values) from the above cell
not the formula. Is there a way to get around this or does the "hidden" also
have to be removed?

Any ideas/suggestions are appreciated.

Thank you in advance.