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