Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding cells from others
This is not the simple question of "I don't know how to hide cells". Is
there any way that I can hide a cell in such a way that even if copied by another user over to a new sheet, they won't see a formula? In other words, I believe that even if rows are hidden, cells are locked, and formulas hidden, with protection turned on, a foreign user could still drag across the whole region and paste right onto a workbook to see how the formulas were derived. Am I right, or am I missing some functionality? -- Boris |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hiding cells from others
Try this:
Set the number format of the cell to: Category: Custom Type: ;;; Set the Protection of the cell to: Locked and Hidden Protect the sheet Now, copy/paste should only pick up the value and NOT the formula. Does that help? *********** Regards, Ron "BorisS" wrote: This is not the simple question of "I don't know how to hide cells". Is there any way that I can hide a cell in such a way that even if copied by another user over to a new sheet, they won't see a formula? In other words, I believe that even if rows are hidden, cells are locked, and formulas hidden, with protection turned on, a foreign user could still drag across the whole region and paste right onto a workbook to see how the formulas were derived. Am I right, or am I missing some functionality? -- Boris |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional formatting...cont. from 9/25 | Excel Discussion (Misc queries) | |||
Display first, second, etc Nonblank Cells in a Range | Excel Worksheet Functions | |||
Hiding cells on condition | Excel Worksheet Functions | |||
Convert data type of cells to Text,Number,Date and Time | Excel Worksheet Functions | |||
copy group of cells to another group of cells using "IF" in third | Excel Worksheet Functions |