Hello,

In a same Excel-sheet, I want to unlock initial columns (Columns from A to U) to let people edit these columns, and I want to protect some columns (Columns from V to Y) that people shouldn't be able to edit these columns at all.

I am trying two approaches as below, and both cases give me "unlocked columns A-U" and I can edit the content of them, which is good. But other functions are inactivated, like "Hide", "Unhide", "Delete column" or "Insert column". I want to be able to use these functions for the unlocked range or columns.

Do you know if it is possible?


Either I unlock the columns from O to U which I want to be able to edit
Please Login or Register  to view this content.
or I unlock the Range as below:
Please Login or Register  to view this content.