I have a spreadsheet which is protected, but has a large range of unprotected cells for data entry by other users.
No matter where I try to put it, Calc will not allow a hyperlink to a document in the form of a button. I get “Protected cells cannot be modified”, even if I am trying to place the button on unprotected cells. You have to unprotect the entire sheet in order to insert a button, then protect it again.
Hyperlinks are allowed in the form of text links on a protected sheet, but a button is not.
Explanations or workarounds?