hiding a cells

  • Thread starter Thread starter pandino
  • Start date Start date
P

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!
 
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", "")
 
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
 
Back
Top