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
|