Can I assign scripts to inserted images within cells or hyperlinks in Google Sheets? -

i'm curious if there's way “assign script” image inserted cell using =image(“url”) method google sheets? if not, there way “assign script” hyperlink?

what i’d create table of contents tab inside google sheet has many other tabs. on table of contents, i’d love have inserted images act buttons navigate these different tabs. can “assign script” images have been inserted through menu toolbar (e.g., insert > image or insert > drawing). however, it’s extremely clunky have realign images if new row inserted table of contents.

i use hyperlinks navigate each tab, don’t how opens new window every time click on hyperlink. , don’t how requires 2 clicks of hyperlink (one click hyperlink, , click web address pops up) arrive @ desired tab.

so guess, there option exists insert image inside cell, can assigned script?

this functionality helpful.

thanks time!

i've been searching , haven't found way insert link image placed =image () option. i've resorted text , formatting .

you can assign script change tabs via "floating" images inserted via insert menu. on picture on top right corner click arrow , assign script " gotopage1 " or whatever decide call function , page. it's not fast excel works

var ss = spreadsheetapp.getactivespreadsheet();     function gotopage1(){       ss.setactivesheet(ss.getsheetbyname("page1"));     }