ExcelBanter - Is it possible...

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - Is it possible... (https://www.excelbanter.com/excel-worksheet-functions/132477-possible.html)

Kris79

Is it possible...

Is it possible to lock and/or hide formulas but still be able to copy
them to a new sheet?

macropod

Is it possible...

Hi Kris,

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.

Cheers

--
macropod
[MVP - Microsoft Word]
-------------------------

"Kris79" wrote in message oups.com...
Is it possible to lock and/or hide formulas but still be able to copy
them to a new sheet?

All times are GMT +1. The time now is 05:28 AM.