hiding cells from others

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

BorisS - 14 Dec 2005 06:51 GMT

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?

Signature

Boris

Reply to this Message

Ron Coderre - 14 Dec 2005 14:36 GMT

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

> 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
[quoted text clipped - 4 lines]
> 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?

Reply to this Message