Protecting Columns

[nparsons75]

Hi,

Is it possible to protect certain columns with a password. I would like to password protect some columns in order to allow only a certain number of authorised people to edit them?

Thanks,

 

[nemmi69]

if you look under format cells the last tab is protection. What you need to do is untick all cells that you want editable then you can set a worksheet password allowing only editable cells to be entered.

by code this is
Locking

Columns("D:D").Locked = True

Unlocking

Columns("D:D")..Locked = False

 

[nparsons75]

Hi,

Ok, so I have two different levels of people of whom I would like to be able to edit certain things. For example, supervisor can edit some areas and a manager with have more areas available to edit?

Would that be possible. I need all to view but only access as needed.

Thank you again

 

[nemmi69]

Well found this courtesy of Microsoft

https://support.microsoft.com/en-gb...asswords-or-permissions-to-separate-ranges-in

 

[nparsons75]

Hi, that was looking great, I have tried it in excel 2016, the option is there but will not work...

 

[nemmi69]

Have to say, not tried it myself. I have built my own multi-password system in the past but its not straight forward