My objective is to use the protected features to lock many Google sheets, with some unprotected ranges. Works really great, however my problem is that drawings are also protected now - not something I intended.
Can I somehow add a drawing to the unprotected ranges - or is there another way where I can allow the users of the spreadsheet to edit comments (I use a drawing for a text-box)?
Issue: to be able to have a protected sheet where everything apart from drawings is editable.
In the sheet you want to protect, instead of selecting the whole sheet to protect you can instead protect a range selecting the range that contains all your sheet (i.e, in the default sheet this would be from A1:Z1000
. This will effectively protect your sheet while allowing you to insert and/or edit drawings.