google apps script - Is it possible to use a cell with a url linked object to trigger a function?

Question

I am trying to create a spreadsheet that has sections that are hideable by buttons in the spreadsheet. using insert images or shapes will not work as the place that they need to be located will get hidden which places the buttons in the wrong place.

Answer 1

Cell links can't be used to trigger a function from a server sided bounded script project but they could be used to run a web app.

It's worthy to note that could be a lot easier to use a sidebar to put there the buttons that you need.