How can I password protect a particular column?

S

Shamim

I want to hide a column and protect it by a password, so that people may work
on (edit) in other columns and rows with out being able to unhide my hidden
column.
Is that possible?
pls email me: (e-mail address removed)
or (e-mail address removed)
Thanks
 
G

Gord Dibben

You can hide that column then protect the worksheet with a password.

First unlock all cells in the sheet, then lock the column to hide.

Now hide the column.

Tools>Protection>Protect Sheet with a password.

Note: Excel's interanl security is very weak and passwords easily broken.


Gord Dibben MS Excel MVP
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Setting column width in a table with a macro is not working 0
Need Help with a VBA subroutine 0
Non cumbersome way to hide and protect a column? 2
Password for running Macro 2
How can I password protect a hidden column in Excel? 8
hide, unhide column or row after protect worksheet 2
unhiding formulas 3
how to protect a column in a spreadsheet 6

Top