Lock all of column C except the first question in each series and use this code
Code:Private Sub Worksheet_Change(ByVal Target As Range) If Target.Column = 3 Then Me.Unprotect "password" With Target.Offset(1, 0) If Not .MergeCells Then .Locked = False End With Me.Protect "password" End If End Sub
Bookmarks