Link to home
Start Free TrialLog in
Avatar of Frank Freese
Frank FreeseFlag for United States of America

asked on

Lock specific columns

Folks,
I would like to only locked some specific columns in my worksheet: Columns H:O
Avatar of rspahitz
rspahitz
Flag of United States of America image

The easiest way to do this is to select all of the other columns and unlock them (right-click and select Format cells, then click on the protection tab and de-selected the Lock checkbox.

With that done, turn on protection (Alt+H-O-P: Home tab, Cells group, Format selection, Protection item).  With that you will get a window, probably with the first two checkboxes selected.  Deselect the first one "Select locked cells" and click the OK button so that people can only select Unlocked cells.
Avatar of Frank Freese

ASKER

Got a problem here. I incorrectly stated my objective. I meant to say that columns H:O need the width to be "frozen" not locked. My fault.

"Columns A - I" have some cells that are not locked and the worksheet is protected.
Is there a way that when a worksheet is activated you can code what columns are frozen, not locked for a specific column range, such as H:O?
In range H2:O18 I have those cells unlocked.
ASKER CERTIFIED SOLUTION
Avatar of rspahitz
rspahitz
Flag of United States of America image

Link to home
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
Start Free Trial
rspahitz
thanks - not what I was wanting but not surprised.
Appreciate it!
many thanks