Hello all! Not sure if this is the right thread topic, but hoping someone can help - 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?