I have spreadsheets where there are a number of hyperlink buttons to web pages.
Obviously, I just click on any button to open the target in my browser.
Is it possible to create a trigger in a data validated cell that would present me with a drop-down list of all the hyperlinks and I just select/trigger the target I require?
I would envisage creating the hyperlinks in a “utility sheet” as a column of either text or button links and then simply identifying the contiguous array as the valid items and selecting the one required at that moment.
I’ve experimented with both text and button links, validating entries for an adjacent cell as the local array of three hyperlink cells.
Text link cells simply display and accept the text for valid entries and button link cells produce an empty validation list - rejecting the text on the button as invalid entries, thereby making the only valid entry “nothing”.
Many thanks in anticipation.