VBA: password set when workbook closes

[bamaisgreat]

thanks for looking at my post.
I would like to create some code that when my workbook "MasterArchive" is closed that the password"Secret" for sheet"CuttingList" is put in place. Arguments=the password may already be set and if so the code would end, but if the password has not been set for the sheet then have it done upon closing.

 

[Jaafar Tribak]

Something along these lines :

Private Sub Workbook_BeforeClose(Cancel As Boolean)
    With Worksheets("CuttingList")
        If Not .ProtectContents Then
            .Protect "Secret"
        End If
    End With
End Sub