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