Sorry but no luck recreating the problem starting with a workbook in Excel
2003.

--
Jim
"Gizmo" wrote in message
...
| If I create a workbook in 07 and protect it, password is required to
| unprotect. Only the workbook I created in 03 and converted to 07 doesn't
| require a password except on sheet1.
|
| "Jim Rech" wrote:
|
| 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?
|
|