Thread
:
Can I protect all excel tabs in a file with one password entry?
View Single Post
#
6
June 11th, 2008, 11:12 PM posted to microsoft.public.excel.misc
Dave Peterson
external usenet poster
Posts: 19,791
Can I protect all excel tabs in a file with one password entry
Just use
ws.unprotect password:="123"
to unprotect the sheets. They all share the same password, right?
Jen@ccbcc wrote:
Does anyone know how to do the reverse (i.e. unprotect all sheets at once)?
"Paul B" wrote:
Indiana, you can use a macro like this,
Sub protect_sheets()
Dim ws As Worksheet
For Each ws In ThisWorkbook.Worksheets
ws.Protect 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
"Indiana born" Indiana
wrote in message
...
I have spreadsheets with multiple tabs - I presently have to password
protect
each tab separately. I'm looking for a way to protect all tabs with one
password entry. i am not share the files, but others do view them and I
don't want changes made.
--
Dave Peterson
Dave Peterson
View Public Profile
View message headers
Find all posts by Dave Peterson
Find all threads started by Dave Peterson