Search code examples
google-sheets

Add google sheet drawing to unprotected range?


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)?


Solution

  • 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.