Home > other >  Old google sheets buttons not workin
Old google sheets buttons not workin

Time:11-20

About two years ago I created a sheet with some buttons with some code. I just recently wanted to work with it again, and all of the buttons are disabled, and I don't see the code I used for the buttons. How can I "reactivate" my code?

I know there was "script" there before, but when I click on the 3 dots, and "assign script" nothing shows up.

CodePudding user response:

Have you tried going into Extensions > Apps Script yet? In there you should see your custom script code. Once in there, you can check to ensure your code is all correct.

CodePudding user response:

  • Go to the Tools > Script editor menu and verify that the function that you want to trigger is still in the code.
  • Right-click on the button.
  • Left-click on the three dots.
  • Left-click on Assign script.
  • Type the name of the function in the textbox.
  • Click OK.

The next time you left-click the button, the function should run. You may need to authorize the script, then run it.

  • Related