I have a series of sheet and graphs as sheet tabs in the same work book and i would like the macro code to protect and unprotect them all rather than just the worksheets. I use
For Each ws in Sheets
ws.protect Password:="password"
Next ws
End sub
Thanks
For Each ws in Sheets
ws.protect Password:="password"
Next ws
End sub
Thanks