Trying to run a script triggered by an image inserted in a protected sheet. The sheet is shared by several users. oOly the author is enabled to edit; all other users are locked out via setDomainEdit(false)
, except for range ('a1:b3').
when a user clicks the image a script is called to execute (simple msgbox function --> Browser.msgBox("Clicked");
),
Google sheets is returning an error message:
Exception you are trying to edit a protected cell or object. Contact the spreadsheet owner to remove the protection if you need to edit.
the image is a .jpg inserted above cells in the unprotected range ('a1:b3').
QUESTION:
is there any way to unprotect/ unlock an image (within a protected sheet) to enable a script to run when clicked by all users?
(if necessary, the image can be replaced by a google 'drawing' or any other clickable object that would run the required script/ whose properties can be modified to enable the script to run -- but the sheet must remain locked).