How to lock a column
 

I want to lock column B in my worksheet (meaning I want it hidden and no one
should be able to unhide it). And also, I have two tabs in my worksheet that
I don't want anyone to see but they need to be in that file.

Thanks!


--
Message posted via http://www.officekb.com

These would depend on the security of a protected worksheet/workbook.

The bad news is that worksheet/workbook protection (under tools|protection) in
excel is not made for this kind of thing. It can be broken in a matter of
minutes.

If you really have secure data that other shouldn't see, don't put it in
excel--or don't share that workbook with others.

"Patty via OfficeKB.com" wrote:

I want to lock column B in my worksheet (meaning I want it hidden and no one
should be able to unhide it). And also, I have two tabs in my worksheet that
I don't want anyone to see but they need to be in that file.

Thanks!

--
Message posted via http://www.officekb.com

--

Dave Peterson