How do I modify the following code in excel to only lock certain sheets, for example I want to only lock sheets "RFQ" and "QA_CLAUSES" in my workbook.
Dim oWs As Worksheet
sPw = Application.InputBox("What's The Secret Sauce?", "Enter Password Skillit")
If sPw = False Or sPw = "" Then
MsgBox "Nothing Entered"
For Each oWs In ThisWorkbook.Worksheets
If oWs.ProtectContents Then
Else: oWs.Protect sPw