hiding a cells

[pandino]

Hello!
Is it possible to make visible a cell's data only to some
some users and hide cell to some others. How?

Many thanks!

 

[Don Guillett]

You could tie to a cell where the user enters a password and then the
formula or macro could show the cells
=if(a1="Joe","show me", "")

 

[Gord Dibben]

pandino

It is possible manually but would involve several steps and user intervention
with passworded sheet protection and special formatting.

The several steps could be recorded and a macro to lessen the work.

Involves a custom format of ;;; to hide the cells content and "hidden" cells
under Format>Cells>Protection.

Sheet Protection set and passworded. Only those with a password can undo the
formatting to see the contents of the cells and the formula bar.

Having said that......Excel security is very weak and any user with moderate
skills could break the passwords and undo your efforts.

Gord Dibben XL2002