J
Joe Black
how do i stop certain people viewing specified columns in excel and are
viewable only via a password
viewable only via a password
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
D
dominicb
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
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
J
Joe Black
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
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
D
dominicb
Hi Joe Black
Ahhhh! I thinkI see what you mean now. I thought you wanted to hid
columns, but you mean cells.
Not sure if there's an easier way but if you select the cells you wan
to hide the content of and press ctrl + 1, protection and select th
"Hidden" box. Don't invoke the protection yet, but once set this wil
stop the cell contents being visible in the formula bar at the top o
the screen. The contents will still be visible in the cell, so go t
the Number tab and select the Custom format option and set up a custo
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
Dominic
Ahhhh! I thinkI see what you mean now. I thought you wanted to hid
columns, but you mean cells.
Not sure if there's an easier way but if you select the cells you wan
to hide the content of and press ctrl + 1, protection and select th
"Hidden" box. Don't invoke the protection yet, but once set this wil
stop the cell contents being visible in the formula bar at the top o
the screen. The contents will still be visible in the cell, so go t
the Number tab and select the Custom format option and set up a custo
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
Dominic