How can I unprotect grouped worksheets in a workbook as a unit vs individually
R Rob G Mar 3, 2004 #1 How can I unprotect grouped worksheets in a workbook as a unit vs individually
J JE McGimpsey Mar 3, 2004 #2 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
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
