Can I protect all excel tabs in a file with one password entry
I'd bet that the password isn't really 123 for all the worksheets in the
workbook that contains the code.
Maybe you can add a line just to double check:
For Each ws In ThisWorkbook.Worksheets
msgbox "Processing: " & ws.name
ws.Unprotect Password:="123"
Next ws
That may give you a hint.
SLD wrote:
I copied the unprotect macroe
Sub Unprotect_All_Sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Unprotect Password:="123"
Next ws
End Sub
and it is still giving me an error on the 4th line. the passwords are the
same on both macroes.
What am I doing wrong?
--
Dave Peterson
|