I have written several scripts that are executed by pressing a button (implemented with the insert drawing tool). I am wondering if there is a way I can assign a drop down to the button, in order to click it and then select which script I would like to run.

The situation is:

The button name will be Slope. I would like to click on it and be able to choose 2:1,4:1 or 6:1. Or have the button execute a pop up menu with those options to execute the applicable script.

1 Answer 1


At this time it's not possible to add a drop-down to an inserted image. The alternatives are to open an HTML dialog, a side-bar or a custom menu. For details, see the following official guides:

  • I will look into these some more. I have read into them some but am struggling to understand how to get it all to work as I don't have much programming experience. I am looking to click the button, have that open a pop up menu within the spreadsheet, the pop up menu would have two or three different check boxes and a different script would execute depending on which checkbox you clicked? Is this possible?
    – jnohl
    Sep 19, 2016 at 21:25
  • 1
    Personally I would recommend using a Custom menu for what you are describing. The use of top level, and sub menu choices sounds like it will do what you want.
    – Folk
    Sep 19, 2016 at 21:48
  • @jnohl: Yes, it's possible, I think, but if you are just starting with Google Apps Script I think that you should try first the custom menus.
    – Rubén
    Sep 19, 2016 at 22:31
  • Ruben- I have made the custom menus but that is not really what I am looking for. This will be done many times repetitively so I don't want the user to have to go up into the menu's each time. I am looking for the button functionality, where the button is located somewhere on the sheet, when pressed, you are prompted for two options and a different script will execute based on which option you choose.
    – jnohl
    Sep 20, 2016 at 0:16
  • That's fine. By the way if you are looking for help on how to do that, please post a new question.
    – Rubén
    Sep 20, 2016 at 0:20

Your Answer

By clicking “Post Your Answer”, you agree to our terms of service and acknowledge that you have read and understand our privacy policy and code of conduct.

Not the answer you're looking for? Browse other questions tagged or ask your own question.