Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Is it possible...
Is it possible to lock and/or hide formulas but still be able to copy
them to a new sheet? |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|