How would I do that?? I want to add it to my existing workbook_open code so I can protect the worksheet tab name:
Private Sub Workbook_Open()
Application.ScreenUpdating = False
With Worksheets("Immuno-Assay")
If Not .AutoFilterMode Then
.Range("A1").AutoFilter
End If
.EnableAutoFilter = True
.Protect Password:="", _
contents:=True, userinterfaceonly:=True
End With
With Worksheets("Freezer Diagrams")
.Protect Password:="", _
contents:=True, userinterfaceonly:=True
End With
With Worksheets("ReadMe")
.Protect Password:="", _
contents:=True, userinterfaceonly:=True
End With
End Sub
How do I go about this one?