agwalsh
asked on
Two hyperlinks in a cell in Excel - possible?
hi Folks
Got asked an odd question...the person wanted to know if it was possible to have two hyperlinks in the same cell. I was inclined to say No. But wanted to check first. I'm sure it can be done with some VBA wizardry but it's not that high a priority for the person. Is it possible?
Got asked an odd question...the person wanted to know if it was possible to have two hyperlinks in the same cell. I was inclined to say No. But wanted to check first. I'm sure it can be done with some VBA wizardry but it's not that high a priority for the person. Is it possible?
ASKER CERTIFIED SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
SOLUTION
membership
This solution is only available to members.
To access this solution, you must be a member of Experts Exchange.
I tries peter's suggestion above, but the comment hyperlink does not appear to be clickable
There is a method/workaround where you could use the OLE features of Excel to insert objects from programs
that support multiple hyperlinks.
http://excel.tips.net/T002805_Putting_More_than_One_Hyperlink_in_a_Cell.html
This clunky method uses a vlookup to make the cell dynamic and allow a choice of hyperlinks
http://www.mrexcel.com/forum/excel-questions/708705-single-cell-multiple-hyperlinks.html
There is a method/workaround where you could use the OLE features of Excel to insert objects from programs
that support multiple hyperlinks.
http://excel.tips.net/T002805_Putting_More_than_One_Hyperlink_in_a_Cell.html
This clunky method uses a vlookup to make the cell dynamic and allow a choice of hyperlinks
http://www.mrexcel.com/forum/excel-questions/708705-single-cell-multiple-hyperlinks.html
That was bad luck, the question closed while I was researching!
(and there also other solutions out there)
(and there also other solutions out there)
ASKER
@Eirman - this user just asked me in passing because he had come across it once before. I think the mrexcel solution would be the equivalent of a sledgehammer and a nut :-). He just wanted an easy way and while my feeling was that it wasn't possible I just wanted to check for him. But thanks for looking to research it anyway :-) appreciated.
ASKER