why can i no longer protect multiple worksheets in Excel

J

jjinlotusland

In previous versions of Excel, you could select a series of worksheets and
unprotect or protect them. Apparently this is no longer possible. When i
select more that 1 sheet "protect sheet" function becomes grayed out.
 
M

Michael

Hi
Jason Morin submitted this macro back in December to do what you require.

Try a simple macro like this:


Sub ProtectAll()
Dim ws As Object
For Each ws In ThisWorkbook.Sheets
ws.Protect Password:="1234"
Next
End Sub


Right-click on a tab, select View Code, and then double
click on ThisWorkbook to your left in insert the above
macro. Also,change the password from 1234 to whatever you prefer.

HTH
Michael Mitchelson
 
Top