Format unlocked cells with VBA in a protected sheet but not locked cells

Here's a Contextures Blog post, happily titled "Autofit Merged Cell Row Height"

I urge you to read the whole post, but here's the code:

Private Sub Worksheet_Change(ByVal Target As Range)
Dim MergeWidth As Single
Dim cM As Range
Dim AutoFitRng As Range
Dim CWidth As Double
Dim NewRowHt As Double
Dim str01 As String
str01 = "OrderNote"
  If Not Intersect(Target, Range(str01)) Is Nothing Then
    Application.ScreenUpdating = False
    On Error Resume Next
    Set AutoFitRng = Range(Range(str01).MergeArea.Address)

    With AutoFitRng
      .MergeCells = False
      CWidth = .Cells(1).ColumnWidth
      MergeWidth = 0
      For Each cM In AutoFitRng
          cM.WrapText = True
          MergeWidth = cM.ColumnWidth + MergeWidth
      Next
      'small adjustment to temporary width
      MergeWidth = MergeWidth + AutoFitRng.Cells.Count * 0.66
      .Cells(1).ColumnWidth = MergeWidth
      .EntireRow.AutoFit
      NewRowHt = .RowHeight
      .Cells(1).ColumnWidth = CWidth
      .MergeCells = True
      .RowHeight = NewRowHt
    End With
    Application.ScreenUpdating = True
  End If

End Sub

This has to do with the nature of worksheet protection. The purpose of locking cells is to prevent users from changing the contents. If users delete rows, they will be permanently changing the cells, so it makes sense that Excel doesn't allow users to delete rows with locked cells. What's confusing is that Excel gives you the option to select "delete rows" in the worksheet protection dialog, even though that setting doesn't seem to do anything. The only complete solution is to use macros to unprotect the sheet, delete/copy the rows, and protect it again. If you want the cells to be locked for most users, but allow some users to delete rows, another option is to use the "allow users to edit ranges" feature to allow particular users or users with a password to modify cells even though they are locked. See How to Sort Locked Cells in Protected Worksheets That article is about sorting, but it explains the relevant concepts well.