how can i hide the formulas without hiding cell or column
so that another user cant see which formula is been used.

- Right-click on any range/ cell
- Select Format
- Select "Protection" tab
- Select "Hidden"

it has no effect until it is protected.

*** Please do rate ***



"hitesh" wrote:

how can i hide the formulas without hiding cell or column
so that another user cant see which formula is been used.

.. it has no effect until it is protected.

Just to add on a little to complete the above line ..

The "it" refers to the worksheet,
so we'd need to apply sheet protection via clicking:
Tools Protection Protect Sheet Password? OK
to achieve the desired effect of hiding the formulas
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---

The password on sheet protection is easily cracked so be aware that hiding the
formulas keeps only the novice from seeing them.


Gord Dibben MS Excel MVP

On Wed, 30 Aug 2006 02:16:02 -0700, Max wrote:

.. it has no effect until it is protected.

Just to add on a little to complete the above line ..

The "it" refers to the worksheet,
so we'd need to apply sheet protection via clicking:
Tools Protection Protect Sheet Password? OK
to achieve the desired effect of hiding the formulas

THANKS NAVEEN