Can I assign scripts to inserted images within cells or hyperlinks in Google Sheets?
<p>I'm curious if there's a way to “assign script” to an image inserted into a cell using the =IMAGE(“URL”) method for Google Sheets? If not, is there a way to “assign script” to a hyperlink? </p>

<p>What I’d like to do is create a table of contents tab inside a Google Sheet that has many other tabs. On the table of contents, I’d love to have inserted images that act as buttons to navigate to these different tabs. I can “assign script” to images that have been inserted through the menu toolbar (e.g., Insert > Image or Insert > Drawing). However, it’s extremely clunky to have to realign my images if a new row is inserted into the table of contents.</p>

<p>I could always just use hyperlinks to navigate to each tab, but I don’t like how it opens a new window every time you click on the hyperlink. And I don’t like how it requires two clicks of a hyperlink (one click for the hyperlink, and then another click for the web address that pops up) to arrive at the desired tab.</p>

<p>So I guess, is there any option that exists to insert an image inside a cell, which can then be assigned a script?</p>

<p>This functionality would be so helpful.</p>

<p>Thanks for you time!</p>