data only visible by using a password
 

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

data only visible by using a password
 

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.
--
HTH...

Jim Thomlinson


"mariekek5" wrote:

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

data only visible by using a password
 

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

On Fri, 19 Jun 2009 03:26:01 -0700, mariekek5
wrote:

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

data only visible by using a password
 

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

Luke M
*Remember to click "yes" if this post helped you!*


"Gord Dibben" wrote:

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

On Fri, 19 Jun 2009 03:26:01 -0700, mariekek5
wrote:

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