Whenever I try to open any macro enabled sheets it requires authorization, even though it's a first party application. Is there any way to stop Sheets from asking it or give permissions to everyone I want to at some sort of permissions page? The files that I'm using right now is shared through Team Drive, where all of the participants of the Team Drive have also been added as "Content Manager".

1 Answer 1


There is no way to disable the authorization needed to open Google Sheets Macros.

The authorization dialog is triggered when the user attempt to run an script that requires authorization to execute.

Some alternatives probably among others are:

  • Remove the bounded script
  • Replace the bounded script by an add-on, so the authorization is required only once no matter how many spreadsheets use that add-on

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service, privacy policy and cookie policy

Not the answer you're looking for? Browse other questions tagged or ask your own question.