worksheet protection

  • Thread starter Thread starter Rob G
  • Start date Start date
R

Rob G

How can I unprotect grouped worksheets in a workbook as a
unit vs individually
 
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
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Excel Protection 2
Unprotecting worksheet/workbook in Excel 2007 2
Copying cells in a protected worksheet 2
Worksheet Protection / Security from Viewing 1
How to enable the Unprotected Worksheet menu 2
To protect all worksheet simultaneously in a excel workbook 1
Unprotect problem 2
Protecting Worksheets 1

Back
Top