A
A
Aleksandr2020-04-29 18:48:29
Google Apps Script
Aleksandr, 2020-04-29 18:48:29

How to close and open access for editing in a sheet of ONE cell in a function?

At the beginning of the function, close editing of one table cell and at the end of the function, open editing access.
Also take into account that the access rights of users after this function would not be violated.
For users, the sheet is closed for editing with a range exception.

Answer the question

In order to leave comments, you need to log in

1 answer(s)
A
Alexander Ivanov, 2020-05-01
@iSeb

This cannot be done. Well, or you can, but it’s completely nonsense.
To intercept a "double click" you must block the re-execution of the code until the current one is executed. I usually use LockService for this .
Scripts are REST. REST is a stepwise state change. There are no "clicks" "setTimeout" and so on in Tables. And there is no access to the interface, only small inclusions of frames on the GAS in the allowed areas of the application (alert, dialog, sidebar, menu, toast).

Didn't find what you were looking for?

Ask your question

Ask a Question

731 491 924 answers to any question