Excel 07 Protection

  • Thread starter Thread starter Gizmo
  • Start date Start date
G

Gizmo

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?
 
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
|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?
 
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.
 
Sorry but no luck recreating the problem starting with a workbook in Excel
2003.

--
Jim
| 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
| > | > |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?
| >
| >
 
Back
Top