Tuesday, November 07, 2006

Protecting worksheets...

One feature that I find very useful when building applications is the ability to protect only the user interface.


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).