Protecting multiple sheets and then saving the file

[rneilson52]

I have a spreadsheet which is recording activities and then producing reports. I wnat to be able to protect the 8 sheets so they cannot be changed except by those with the password and then saving the file. I'm getting stuck on the save code. Any help greqtly appreciated

 

[footoo]

ActiveWorkbook.Save

or

Workbooks("workbook name.xlsm").Save

 

[rneilson52]

Need to protect the sheets first. The save part is fine

 

[rneilson52]

All good. Have written the code and it is working

 

[Peter_SSs]

Good to hear you found a solution.
If you would like to post the solution then it is perfectly fine to mark your post as the solution to help future readers. Otherwise, please do not mark a post that doesn't contain a solution.
(I have removed the solution mark from post 4)