Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I unprotect multiple same passoword worksheets at once?
We have created a large number of workbooks containing worksheets that are
protected, except for a few cells, all with the same password. Is there any way to remove protection from multiple worksheets at one time? We are trying to avoid having to open each worksheet at a time, changing the one protected text cell that needs changing, and then putting protection back on. |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
How can I unprotect multiple same passoword worksheets at once?
On Apr 22, 8:25*pm, tomster3
wrote: We have created a large number of workbooks containing worksheets that are protected, except for a few cells, all with the same password. *Is there any way to remove protection from multiple worksheets at one time? *We are trying to avoid having to open each worksheet at a time, changing the one protected text cell that needs changing, and then putting protection back on. Hi With all workbooks open this macro will unprotect all sheets in all worksheets. Sub RemovePassword() MyPassword = "PassWrd" For Each wb In Application.Workbooks For Each sh In wb.Sheets sh.Unprotect Password:=MyPassword ' To protect sheets change to "sh.Protect Password...." Next Next End Sub Regards, Per |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
How to protect and unprotect multiple worksheets effeciently | Excel Discussion (Misc queries) | |||
Protect/Unprotect Multiple Worksheets | Excel Discussion (Misc queries) | |||
Protect/unprotect worksheets | Excel Programming | |||
Protect/unprotect all worksheets | Excel Worksheet Functions | |||
protect / unprotect worksheets using VBA | Excel Programming |