Make shape hyperlink to sheet based on cell value

[craigg3]

Im able to put a link in a cell, such as =HYPERLINK("#'"&X3&"'!A1","GO"), where X3 contains a sheet name and the sheet name will change often. This works fine if link is placed directly in a cell, but I can not get it to work if trying to hyperlink using a shape. Any suggestions on how to make it work for by clicking a shape instead of a cell? Would prefer it to work without using VBA.

 

[Micron]

I cannot imagine it's possible without code given that a formula bar has no awareness of a shape click event. Happy to be proved wrong though. Code is as simple as

Sub IsoscelesTriangle3_Click()
ThisWorkbook.FollowHyperlink "https:\google.ca"

End Sub

 

[craigg3]

Thanks Micron, it may not be possible without code, I couldn't figure it out anyway.
Was just trying to keep the spreadsheet simple (macro free) for users so they wouldn't have to go through the process of enabling macros/unblocking...

 

[Micron]

I asked if a shape could have a formula or hyperlink. Couple of examples:

https://www.google.ca/url?sa=t&source=web&rct=j&opi=89978449&url=https://www.youtube.com/watch%3Fv%3DqXiev-KQFK4&ved=2ahUKEwibueHUzJ2IAxX1m4kEHXJmAv8QtwJ6BAgfEAI&usg=AOvVaw3memFq0eWzMPVGfe4eRC1B

How To Link Excel Shapes to Worksheet Cells | BreezeTree

How to link an Excel shape (autoshape) to a worksheet cell, so the shape text is updated when the cell changes.

www.breezetree.com

or maybe get creative with textbox embedded in shape but formatted to not look like a tb.