Protection

K

Keith

Is it possible to apply password protection to an entire spreadsheet without
having to go to each individual worksheet ?

Thanks,
Keith
 
H

Harald Staff

Hi Keith

No. A common workaround is a macro that loops all sheets and lock/unlock:

Sub LockMe()
Dim Wks As Worksheet
For Each Wks In ActiveWorkbook.Worksheets
Wks.Protect Password:="******"
Next
End Sub

HTH. Best wishes Harald
 
K

Keith

Thanks,
Keith



Harald Staff said:
Hi Keith

No. A common workaround is a macro that loops all sheets and lock/unlock:

Sub LockMe()
Dim Wks As Worksheet
For Each Wks In ActiveWorkbook.Worksheets
Wks.Protect Password:="******"
Next
End Sub

HTH. Best wishes Harald
Click to expand...
 
Top