Home |
Search |
Today's Posts |
#1
![]() |
|||
|
|||
![]()
I have been using the following code to protect all worksheets in a workbook:
Public Sub ProtectAll() Const PWORD As String = "mysecretword" Dim wsSheet As Worksheet For Each wsSheet In Worksheets wsSheet.Protect Password:=PWORD Next wsSheet End Sub This password protects all sheets without exceptions. Is there any way to modify the code so that it protects all sheets but it universally allows editing of objects, autofilter, and Pivot reports? |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Worksheet protection with grouped rows? | Excel Worksheet Functions | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
Worksheet tab protection | Excel Discussion (Misc queries) | |||
copyright and worksheet protection | Excel Discussion (Misc queries) | |||
Seeking help for total worksheet protection | Excel Discussion (Misc queries) |