Is there a way to use multiple hyperlinks in one cell? I have to link to another excel file's different sheets from in a cell, but couldn't seem to do it when I tried selecting only one of the numbers out of the rest from the cell. Or to bookmark two sheet numbers.
ie, document A's cell with 2,3,7 needs to be linked to doc B's sheet 2,3, & 7.
2006-08-06 16:15:55 · 2 answers · asked by Mex 2 in Computers & Internet ➔ Software
Thanks, I have Visual Basics, but I have no idea how to use it... I saw alot of excel sites that quote loads of terms that I don't understand...
2006-08-06 19:16:02 · update #1
You need to use Visual Basic for Applications - The programming language used by Microsoft Office Applications. Its help can be installed while installing MS-Office.
2006-08-06 18:20:25 · answer #1 · answered by Indian_Male 4 · 0⤊ 1⤋
The problem is that the cell is the hyperlink in Excel, not the text; this is not possible.
2006-08-07 16:26:51 · answer #2 · answered by O Caçador 6 · 0⤊ 0⤋