Column password protection

[Anders]

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!

 

[Nigel]

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