Protecting specific columns from resizing

[Binbs]

Hello,

I would like to restrict users from resizing specific columns in my worksheet and allow them to resize or hide the others.

I've followed the steps to first unlock all cells by selecting the entire worksheet then format, unlocking in the Protection tab. Then I select the two columns I want to protect and lock those ones in the Protection tab.

However, when I protect the worksheet, it prevents resizing all of the unlocked columns as well, not just the ones that I locked.

I'm not sure where I've gone wrong. I see posts about locking and protecting specific cells but not this specific problem.

Thanks for any help!

 

[rlv01]

If it is a macro-enabled workbook, another option is to use VBA to enforce a specific column width of the columns you choose. In other words, the user might change it, but then your VBA code changes it back. Either immediately or at an event you choose (such as the worksheet_deactivate event).

 

[Binbs]

If it is a macro-enabled workbook, another option is to use VBA to enforce a specific column width of the columns you choose. In other words, the user might change it, but then your VBA code changes it back. Either immediately or at an event you choose (such as the worksheet_deactivate event).

So great! Thank you. I will look into this.

 

[Binbs]

I found this code which works for resizing the column when I run it.

Sub Set_Column_Range_Width()

Dim MySheet As Worksheet

Set MySheet = ActiveSheet


With MySheet.Columns("C")
 .ColumnWidth = 52.27
End With
End Sub

Is there a way I can trigger this to run if the column is resized?

 

[FryGirl]

Why don't you just lock the spreadsheet to keep this from happening.

 

[Binbs]

Why don't you just lock the spreadsheet to keep t

Thanks for the suggestion. That's exactly what I was trying to do initially but wasn't able to prevent resizing of specific columns (read above).