All,

I have a macro to lock my workbooks for field distribution - ShowPass. Each worksheet has the "select locked cells" unchecked. The cells which require data entry I will individually go to cell properties and uncheck "locked". Once the macro runs, it locks every sheet except the cells pre-selected to be unlocked.

The field guys will enter data into the unlocked cells. This macro was created to standardize all inspection forms....

Sub ShowPass()

    If Sheets(2).ProtectContents = False Then
        UserForm1.Label1.Visible = True
        UserForm1.TextBox2.Visible = True
        UserForm1.Caption = "Protect Worksheet"
    End If
    
    UserForm1.Show

End Sub
I would like to have a macro which locks every cell, every sheet in a workbook, regardless of the worksheet "Protect Sheet" properties. My thought is when I send a sample workbook out for review. Absolutely, no data entry will be able to occur.