Hi,

Is it possible to protect columns in a spreadsheet with a password?

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

Thanks!

You can not protect specific parts of you worksheet with a password. However
you can lock/unlock specific cells, including whole columns, that when the
worksheet 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 sheet 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 sheet, (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
(E-Mail Removed)



"Anders" <(E-Mail Removed)> wrote in message
news:FCB9CA5F-52A7-48BD-985F-(E-Mail Removed)...
> Hi,
>
> Is it possible to protect columns in a spreadsheet with a password?
>
> I would like to hide the contents in specific columns from unauthorized
> users.
>
> Thanks!