worksheet protection

[Rob G]

How can I unprotect grouped worksheets in a workbook as a
unit vs individually

 

[JE McGimpsey]

One way (you have to use a macro):

Public Sub UnprotectGroupedSheets()
Const csPWORD As String = "drowssap"
Dim wsSheet As Worksheet
For Each wsSheet In ActiveWindow.SelectedSheets
wsSheet.UnProtect csPWORD
Next wsSheet
End Sub