Frank Freese
asked on
Lock specific columns
Folks,
I would like to only locked some specific columns in my worksheet: Columns H:O
I would like to only locked some specific columns in my worksheet: Columns H:O
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.
"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
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
ASKER
rspahitz
thanks - not what I was wanting but not surprised.
Appreciate it!
thanks - not what I was wanting but not surprised.
Appreciate it!
ASKER
many thanks
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.