I agree with Tom....

There is one more way which you can hide the contents....

Format Cell - Number - Custom - Enter ;;; (three semicolans) and say ok.

Now hide the cells. The data will not be visible.

Bug as mentioned by Tom if user links to the cell, it will get exposed.

HTH

Yogendra

Tom Ogilvy wrote:

If you select the cells and do
Format=Cells, select the protection tab and click on locked and hidden

Then you have to protect the worksheet. (any cells where you want to allow
entry should be unlocked in the same manner).

Now the hidden cells will not appear in the formula bar. You will still
need to make the text and background colors the same.

I believe that will work.

An alternative would be to put the sensitive data on a separate sheet and
hide the sheet. Then refer to these cells in your formulas.

However, in either approach, if the user links to the cell, they can see the
value - not sure who you are hiding the information from.

Another approach, if it is data, is to put the data in defined names. You
could create these with code and make them not visible.

Again, if the sensitivity is the value of the data, then it would be very
hard to deny this to the person controlling the computer.