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 |
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 |
All times are GMT +1. The time now is 05:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com