Forum Discussion
how to protect sheet
Hi, I have created 35 identical worksheet for my workbook. there are some identical cells that I need to lock. is there an easy way to protect all sheets in the workbook in one go rather than protect...
You could run a macro like this:
Sub ProtectSheets()
Dim w As Worksheet
For Each w In Worksheets
w.Protect Password:="topsecret"
Next w
End Sub