Thanks JMB I think I will create 2 worksheets one for my self and one for the
shared drive. The one on the shared drive will be the exact same worksheet
however it will exlude the column

"JMB" wrote:

Actually, I don't believe you need to even bother breaking the worksheet
protection. If col D is hidden, select columns C through E and copy/paste to
an unprotected sheet and unhide the column w/the info on the unprotected
sheet.

"Dave Peterson" wrote:

If that information cannot be shared with others, then don't put it into an
excel workbook.

If you have to, then don't share it with others.

Excel's worksheet protection is easily broken. It's designed to keep people
from writing over formulas (and the like). It's not meant to protect
information like this.



checkQ wrote:

Hi all.
I have a spreadsheet that I want to place on a shared drive. One column
contains confidential information such as employee name and account balane. I
want to hide the name column so that only I (or others with the password)
have access to that column, but I want others to be able to view and change
the rest of the data.That is, I want them to be able to chane rows insert
columns ect. but I don't want them to.
Is there a way to do this?
Thanks

--

Dave Peterson