Lock specific columns

Folks,
I would like to only locked some specific columns in my worksheet: Columns H:O
Frank FreeseAsked:
Who is Participating?
 
rspahitzConnect With a Mentor Commented:
I think the default for protection is that the column resizing (formatting) is also locked.
I don't know of any events that Excel provides to indicate that a column is resized so you'd have to lock it and provide your own mechanism (like an overlaid button) to allow users to resize parts.
0
 
rspahitzCommented:
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.
0
 
Frank FreeseAuthor Commented:
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.
0
 
Frank FreeseAuthor Commented:
rspahitz
thanks - not what I was wanting but not surprised.
Appreciate it!
0
 
Frank FreeseAuthor Commented:
many thanks
0
Question has a verified solution.

Are you are experiencing a similar issue? Get a personalized answer when you ask a related question.

Have a better answer? Share it in a comment.

All Courses

From novice to tech pro — start learning today.