CODEWITHSUNDEEP
google-apps-scriptgoogle-sheetsgoogle-drive-api
Slav
Slav

Reputation: 27485

Google Spreadsheet - how to modify image that has assigned script?

Everywhere I've read, it says to create a "button" in Google Spreadsheet you need to insert an image and assign a script to it. Easy enough. Done.

Now how do I modify that image? Clicking on the image runs the script. I cannot right-click the image for any context menu. I cannot select the image in any other way. I cannot ever remove the image now.

Upvotes: 1

Views: 2440

Answers (3)

Adham Zahran
Adham Zahran

Reputation: 2180

So that was tricky to me because the anchor was invisible in my image; it had a black background. If you can't see the anchor on your image follow these steps:

  • Right click on the image, You should find that it now has resize handles
  • Move your cursor to the top right of the image until it changes to a hand that points with the index finger (like when you hover over a link)
  • Click
  • Do whatever you want (Edit, delete... etc.)

Upvotes: 0

Frances Cherman
Frances Cherman

Reputation: 133

Perhaps Slav was using a Mac when he tried it the first time. Strangely, in this specific scenario, the Mac equivalent of right-clicking (which is CTRL+click) really does not work. What works is CMD + click.

Upvotes: 6

Mogsdad
Mogsdad

Reputation: 45740

While you can "assign a script" to an image, you can also do so to a drawing - which is much easier to customize. Either way, you end up with a picture in the spreadsheet, and when you click on it a script is triggered.

To edit this behavior, just right-click the image or drawing. (I know you said you did this, but it DOES work. Just click - then let go.) An anchor will appear on the image or drawing, and from there you can access a menu to edit or delete the image or change the attached script.

Screenshot

Upvotes: 3

Related Questions