Is it possible to lock and/or hide formulas but still be able to copy them to a new sheet?
K Kris79 Feb 27, 2007 #1 Is it possible to lock and/or hide formulas but still be able to copy them to a new sheet?
M macropod Feb 27, 2007 #2 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
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
