If you use Format|Cells|Protection and check the 'hidden' option and uncheck the 'locked' option for a given cell, then you can copy
the formula in that cell to a new sheet regardless of whether protection is on or off.
Want to reply to this thread or ask your own question?
You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.
