Right click on sheet1 Select View code
You will see ThisWorkbook double click then paste this
This will protect the workbook every time you close and you
can change "Password" to what you want password to be
Test on new workbook
Private Sub Workbook_BeforeClose(Cancel As Boolean)
'Replace "Password" with your password
'this will set password when closing workbook
ActiveSheet.Protect "Password", True
ActiveWorkbook.Protect "Password", True

End Sub

"Tara at Walsh" wrote:

I have an excel file on a network drive, other people view it. I changed the
protection so that they can only select and autofilter, but cannot edit
cells. However, I have to unprotect it for myself all the time and then I
save it forgetting to protect it again. There has to be an easier way so
that other people can't edit and I don't have to keep putting in password.
Right?