data only visible by using a password

[mariekek5]

Hi,

Is it possible in Excel (preferably not by using macro's or VBA) to make the
data in one column unvisable unless a password is entered?

regards,
marieke

 

[Jim Thomlinson]

Depends on why you are hiding it. My guess is that you do not want
unauthorized people to be able to view the data. In that case... No. You
could use a conditional format to colour the text white based on a password
being entered into a specific cell. However if your user highlights the area
the text will show up or if they created a formula and pointed to that cell
the function would return the value. Finaly if they just select the cell the
value of the cell will show up in the formula bar.

 

[Gord Dibben]

You could hide the column then protect the worksheet with a password.

Excel security is rather weak so this method will prevent casual users
cracking your password.


Gord Dibben MS Excel MVP

 

[Luke M]

No need to crack the password, you could simply have another workbook refer
to the hidden cell.