Google Sheets App Script: Trigger on a copied sheet

I am trying to run a Google Sheets App Script whenever a checkbox is ticked.

  • Other users should be allowed to tick the checkbox.

When ticked, an App Script shows/hides different parts of the sheet.

  • This works fine for the owner of the sheet, but not for other users.

I would like to achieve the following workflow:

  1. User makes a copy of the entire Google Sheet
  2. User shares copy with colleagues
  3. App Script fires for user and colleagues

Things I have tried:

a. Simple Trigger DEMO

  • Using an onEdit Simple Trigger fails for other users due to “You are trying to edit a protected cell or object.”

b. Installable Trigger DEMO

  • Setting up an Installable Trigger allows other users to run the App Script.
  • However, manually setting up a trigger each time the sheet is copied can not reasonably be expected from users.

How would I want to trigger the App Script on a copied sheet?