Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Sheet Protection
is it possible to protect and unprotect multiple sheets?
Regards, Corey |
#2
|
|||
|
|||
Corey, only with VBA, like this
Sub protect_sheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Protect password:="123" Next ws End Sub Sub unprotect_sheets() Dim ws As Worksheet For Each ws In ThisWorkbook.Worksheets ws.Unprotect password:="123" Next ws End Sub -- Paul B Always backup your data before trying something new Please post any response to the newsgroups so others can benefit from it Feedback on answers is always appreciated! Using Excel 2002 & 2003 "Corey Brock" wrote in message ... is it possible to protect and unprotect multiple sheets? Regards, Corey |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Linking to an Entire Sheet | Links and Linking in Excel | |||
Linking sheets to a summary sheet in workbook | Excel Discussion (Misc queries) | |||
linking multiple sheets to a summary sheet | Excel Discussion (Misc queries) | |||
Hyperlink to specific sheet in Excel Web File | Links and Linking in Excel | |||
Cell Colors and Sheet Protection | Excel Discussion (Misc queries) |