I have a workbook with 31 sheets in it. How can I protect/unprotect all 31 at once? It takes too long to do them one at a time and they will all have the same password anyway. Thank You.
I have a workbook with 31 sheets in it. How can I protect/unprotect all 31 at once? It takes too long to do them one at a time and they will all have the same password anyway. Thank You.
Hi,Originally Posted by sls-sls
setup a macro something likehthSub lockIt() Dim wSheet As Worksheet Dim pw As String pw = "password" For Each wSheet In Worksheets wSheet.Protect Password:=pw Next wSheet End Sub
---
Si fractum non sit, noli id reficere.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks