J
J
Jeronico2021-03-31 16:50:22
Google Sheets
Jeronico, 2021-03-31 16:50:22

Why scripts do not work for added users?

Granted access to tables to several users, but scripts do not work for them. I gave access to the document as an editor, however, when trying to enter the script editor, users get an error about the lack of access to the document.

What is characteristic - there is a second similar document with the same rights and scripts, and everything works there.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
J
Jeronico, 2021-04-01
@Jeronico

Found a solution. If there are protections on the sheets (some), then the managers (those who were given access) must first test all the functions so that there is no protection on the sheets, and after everyone starts the scripts, set the protections.
I did the opposite. I distributed accesses, protected the sheets and then called managers into the document, their scripts were worked out very partially, just a few lines. I took off all the protections and everything worked, then I set the protections again and everything is ok.

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question