Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
MS2007 - deleting filtered data, deletes non-visible data too | Excel Discussion (Misc queries) | |||
Help on visible data | Excel Discussion (Misc queries) | |||
Using VB to password protect, but sheet remains visible | Excel Discussion (Misc queries) | |||
Password visible if user selects "view code" | Excel Worksheet Functions | |||
Autoshapes not visible on spreadsheet but visible in print preview | Excel Discussion (Misc queries) |