Auto-Protrect Sheets in Shared Workbook?

[hayleyzim]

Hello all! Is it possible to have a workbook auto-protect the sheets, even as a live (auto-save) file on Sharepoint?
Before uploading this shared workbook to Sharepoint, we had macros set to automatically re-protect all sheets in the workbook. I'm having trouble working out if this function is possible without using a macro (my understanding is you can't make macro-enabled workbooks "live" or "auto-save").
People in my team at work may need to unprotect sheets to update data, and currently each time you unprotect a sheet it clears the password and you need to manually set it up again.
Does anyone know of a way around this by chance?

 

[hayleyzim]

Marking this thread as solved - Been able to find a solution

 

[Fluff]

Glad to hear you got the 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.