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

When I try to open a new macro-enabled spreadsheet, Sheets prompts me to provide authorization even though:

1. The owner of the document and I are part of the same Google Workspace organization.
2. I have already approved the same permissions for previous spreadsheets from that user.
3. The documents are located in a Google Workspace Shared drive (formerly Team drive).
4. All users have been given Content Manager permissions

Is there any way to stop Sheets from repeatedly requesting the same permissions for every new document?

For example, can I identify a particular Workspace user to give blanket permission to so their documents are automatically authorized? 

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

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 are shared through Team Drive, where all of the participants of the Team Drive have also been added as "Content Manager".

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