Re: Column password protection

You can not protect specific parts of you work*** with a password. However you can lock/unlock specific cells, including whole columns, that when the work*** is protected (with or without a password); they can/cannot be selected and /or edited.

You can of course hide a column which is very different to the above, if you hide and then protect the *** you cannot unhide.

I guess if you do not want the user to see the contents, then hide is the best option.

The following will hide column E and then protect the ***, (you can of course do this manually without using a macro)

With Sheets("Sheet1")
.Columns("E:E").EntireColumn.Hidden = True
.Protect Password:="myPassword"
End With


--

Regards,
Nigel
nigelnospam@xxxxxxxxx



"Anders" <Anders@xxxxxxxxxxxxxxxxxxxxxxxxx> wrote in message news:FCB9CA5F-52A7-48BD-985F-CF30179C7908@xxxxxxxxxxxxxxxx
Hi,

Is it possible to protect columns in a spread*** with a password?

I would like to hide the contents in specific columns from unauthorized users.

Thanks!

.