View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
JE McGimpsey JE McGimpsey is offline
external usenet poster
 
Posts: 4,624
Default Unprotect groups

One way:

Public Sub UnprotectGroups()
Const csPWORD As String = "drowssap"
Dim ws As Worksheet
For Each ws In ActiveWindow.SelectedSheets
ws.Unprotect Password:=csPWORD
Next ws
End Sub

In article ,
"Ed Davis" wrote:

Is there a way to unprotect a group rather than having to unprotect each
sheet individually?