-2

I've been trying to create a Google Spreadsheet plugin from some existing Google App Scripts that I have, and one important part of this app script is Custom Functions.

I have seen an addon that can enable the use of custom sheet functions using a Add-on menu

https://prnt.sc/tlnplvxCwLRQ

Any insights are greatly appreciated.

Rubén
  • 34,714
  • 9
  • 70
  • 166
Code Guy
  • 3,059
  • 2
  • 30
  • 74
  • 1
    I ran some test and I notice that the Add On does not disable the functions, it only enables it. I am unable to find any reference from AppScript to disable the functions, this might be just a trigger, if you do the tutorial or select "Clear API Key" it would activate the "=GTP" function. Without pressing the button to enable it. – Ricardo Jose Velasquez Cruz Jan 18 '23 at 22:04
  • Questions on this site should be self contained. Considering this, add the image to the question using the button to add images from the question editor toolbar instead of usind a link to an independent host. Please add a [mcve] and add a brief description of your search efforts as is suggested in [ask]. – Rubén Jan 21 '23 at 05:44
  • 2
    There's no need to be rude. The question could use some improvement. The first comment above already answers the question. – doubleunary Jan 22 '23 at 07:35

1 Answers1

-1

An add-on's custom functions will work for all users of a spreadsheet where the add-on has been enabled by any user. See Installed versus enabled.

To enable an add-on in a spreadsheet, run any function in the add-on. The function does not actually need to do anything. Executing any bit of code in the add-on will cause the authorization dialog box to show, and when you give the authorization, the add-on's status changes to enabled for that spreadsheet, and custom functions in the add-on will run in that spreadsheet for all users. Running a function is usually done through a custom menu item.

To disable an add-on, use the Extensions > Add-ons > Manage add-ons dialog box.

doubleunary
  • 13,842
  • 3
  • 18
  • 51