Protecting Column Widths

[Kirs10c]

I have a bit of a dilemma. I need to only protect the width of my columns. As my users need to have the ability to add/delete rows, make changes to date/text cells, but not be able to adjust the column width.

Is this possible?

 

[SamS]

I'm not sure if this is the best way of dealing with this but you insert following code into the Worksheet module:

Private Sub Worksheet_SelectionChange(ByVal Target As Excel.Range)
Columns("F:F").ColumnWidth = 20
End Sub

The user can try and modify the column width but the moment they move to another cell the width will return to your deafult.