Cell Protection in VB

[Cat129]

Morning All,

I would like to protect a workbook using VB, so that I can add the protection to the end of an update macro I have created

I would like to lock certain columns so they can't be edited at all, some that the user can do what they want with, and others that they can only input data.

Columns A:S - Lock completely, no input, but can select the cells
Columns T:X - Users can input there own info and format cells if they wish
Columns Y:Z - Users can not input data but can format cells if they wish
Columns AA:AE - Users can input there own info and format cells if they wish
Columns AF:... - Lock completely

I would also like to restrict them so they can not add or remove columns or rows

Finally a password at the end

Thanks for your help

Cat

 

[RoryA]

You can't mix and match like that I'm afraid. You either allow formatting of locked cells, or you don't; it is not possible to restrict that to particular ranges.

 

[Cat129]

You can't mix and match like that I'm afraid. You either allow formatting of locked cells, or you don't; it is not possible to restrict that to particular ranges.

I thought that might have been the case, but wanted to check

Thanks for letting me know

Cat