Hi Everyone,
I have a workbook with about 52 worksheets, I have a script that will unlock the protection from all the worksheets. However the problem I'm having is the script runs and starts and ends at sheet1 I want the script to start and end at the sheet I run the script from lets say sheet 40?
Here is what I have now.
Any Ideas?
Thank You for your help!!!
Mike
Sub unProtect()
Dim Wks As Worksheet
For Each Wks In Worksheets
On Error Resume Next
Wks.Select: Wks.Activate
Wks.unProtect "Leith"
Next Wks
End Sub
Bookmarks