software

This is not the simple question of quot;I don't know how to hide cellsquot;. 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

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,
Ronquot;BorisSquot; wrote:

gt; This is not the simple question of quot;I don't know how to hide cellsquot;. Is
gt; there any way that I can hide a cell in such a way that even if copied by
gt; another user over to a new sheet, they won't see a formula?
gt;
gt; In other words, I believe that even if rows are hidden, cells are locked,
gt; and formulas hidden, with protection turned on, a foreign user could still
gt; drag across the whole region and paste right onto a workbook to see how the
gt; formulas were derived. Am I right, or am I missing some functionality?
gt; --
gt; Boris