I couldn't duplicate your problem. After running this code I had to input
the password for each sheet individually to unprotect it..

Sub ProtectAllSheets()
Dim WS As Worksheet
For Each WS In Worksheets
WS.Protect "a", True, True, True
Next
End Sub

--
Jim
"Gizmo" wrote in message
...
|I just got upgraded to Excel 07. I am trying to use an app I created in
Excel
| 03. After converting the file to .xlsm, I started to check to make sure
all
| the code is working correctly. Everything is fine except for the sheet and
| workbook protection. Excel 07 is only requiring me to input the password
on
| sheet 1. All the other sheets "Unprotect" by simply clicking on the
unprotect
| sheet button in the review ribbon. All my "Subs" starts and ends with
| workbook and worksheet unprotect/protect.
| Is this how 07 is supposed to work? What good is sheet protection then?