Answer the question
In order to leave comments, you need to log in
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
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 questionAsk a Question
731 491 924 answers to any question