Problem with protected sheets as they are no longer owned by the user.
Does anyone have a resolution for this problem?
A user creates a Google Sheet, and then protects some of the sheets.
They then move the Google Sheet into an AODocs library and find that they can no longer edit the protected sheets.
The only way round that I can think of, is to export the Google Sheet out of the library to myself and then give the user access to the protected sheets and then put the Google Sheet back in AODocs.
I'd rather not do this as the users are updating the spreadsheets all the time.