One feature that I find very useful when building applications is the ability to protect only the user interface.
I.e.
Sub Protect_sheet(S As Worksheet)
S.Protect UserInterFaceOnly:=True
End Sub
This is incredibly handy as it enables us to make modifications to worksheets via vba (without having to toggle sheet protection off and on all of the time).
