I have an excel sheet where one column consist of comma seprated hyperlinks. However, I am unable to see a way to insert more that one hyperlinks in an excel cell. Is there a workaeround this?
views:
44answers:
2
A:
I think that the Hyperlink is applied to the entire cell, therefore you can't hyperlink a cell to more than one address.
Workaround suggestion (not that I have an idea of why would you need comma-seperated hyperlinks in a single excel cell, but anyhow...): Write a VBA script that performs the required functionality.
M.A. Hanin
2010-04-22 08:31:35
I'm not sure you could do this in VBA. You'd have to have a way to trap which link was clicked on, and there is no XY control on the spreadsheet itself, only on forms. The only thing I could figure is if when the cell is clicked on a userform pops up asking which link the user would like to open. But you might as well have the links in 2 separate cells if you do that.
guitarthrower
2010-04-22 15:39:57
I was thinking more towards the Text Selection, but, you know, implementing a strange feature requires strange thinking.
M.A. Hanin
2010-04-22 17:42:22
A:
You can't do this without an ugly kludge, and I would not advise that.
KCCole
2010-04-24 21:55:51