Home |
Search |
Today's Posts |
#1
|
|||
|
|||
hiding specific columns
how do i stop certain people viewing specified columns in excel and are
viewable only via a password |
#2
|
|||
|
|||
Good morning Joe Black You could protect that fairly easily by using Tools Protection Worksheet Protection. It will keep out all users and will require a password. Now the bad news. It's not very secure at all and anyone who finds newsgroups like this can find code listings and sites that show the code that would be required to remove the password. The bottom line - it can be used to prevant accidental change or erasure and will keep out some users, but if you want to keep something secret, don't store it in Excel. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=469810 |
#3
|
|||
|
|||
thanks Dominic. i am aware of the password crackers. but with the protection
method that you told me, aren't the cells still viewable? is it possible to hide the cells when protected? thank you for you input so far "dominicb" wrote: Good morning Joe Black You could protect that fairly easily by using Tools Protection Worksheet Protection. It will keep out all users and will require a password. Now the bad news. It's not very secure at all and anyone who finds newsgroups like this can find code listings and sites that show the code that would be required to remove the password. The bottom line - it can be used to prevant accidental change or erasure and will keep out some users, but if you want to keep something secret, don't store it in Excel. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=469810 |
#4
|
|||
|
|||
Hi Joe Black Ahhhh! I thinkI see what you mean now. I thought you wanted to hide columns, but you mean cells. Not sure if there's an easier way but if you select the cells you want to hide the content of and press ctrl + 1, protection and select the "Hidden" box. Don't invoke the protection yet, but once set this will stop the cell contents being visible in the formula bar at the top of the screen. The contents will still be visible in the cell, so go to the Number tab and select the Custom format option and set up a custom format of ;;; All cells with this format will be rendered invisible. You can now set the protection. Obviously to view the cells a user has to do these steps in reverse, but there's nothing to stop you setting up a macro to undo this. HTH DominicB -- dominicb ------------------------------------------------------------------------ dominicb's Profile: http://www.excelforum.com/member.php...o&userid=18932 View this thread: http://www.excelforum.com/showthread...hreadid=469810 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
hiding columns, error message says cannot shift objects off sheet | Excel Discussion (Misc queries) | |||
averaging specific rows in multiple arrays | Excel Worksheet Functions | |||
can you prevent viewing of specific columns in a worksheet | Excel Worksheet Functions | |||
Hiding columns based on user/password | Excel Worksheet Functions | |||
Counting the Contents of Two Columns | Excel Discussion (Misc queries) |