if you add the following to the ThisWorkbook module your code will be able to do almost anything without issue
Private Sub Workbook_OPen()
dim ws as worksheet
for each ws in me.worksheets
   ws.protect password:="your password here", userinterfaceonly:=true
next ws
end sub