R
Rechie
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.
You are using an out of date browser. It may not display this or other websites correctly.
You should upgrade or use an alternative browser.
You should upgrade or use an alternative browser.
B
BSc Chem Eng Rick
No, why do you want to do this?
P
Pete_UK
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.
Pete
function. Give us some more details of what you want to achieve.
Pete
R
Rechie
Hi ,
Example is in A1 =Main Project Name
Under this Main Project name , there are 3 more sub projects that I want to
link the details. Work sheet is only visible with MainProject .
Example is in A1 =Main Project Name
Under this Main Project name , there are 3 more sub projects that I want to
link the details. Work sheet is only visible with MainProject .
P
Pete_UK
I'm sorry, but that doesn't make any sense to me.
Please try to describe what you have and what you want to do with it.
Pete
Please try to describe what you have and what you want to do with it.
Pete
J
Jon Peltier
You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink.
- Jon
linked to a macro that follows a particular hyperlink.
- Jon
R
Rechie
In a simple way, If possible I need to have 3 links in a single cell (Project
Name), because this particular Project has 3 documents lying in other
places. In a normal sitiuation I have to type the same Project name in 3
different cell range (A1,A2 and A3) and link it individually to 3 different
Docs.
e.g.
A1= "Project A" link to Doc1
A2 = "Project A" link to Doc2
A3 = "Project A" link to Doc3
Name), because this particular Project has 3 documents lying in other
places. In a normal sitiuation I have to type the same Project name in 3
different cell range (A1,A2 and A3) and link it individually to 3 different
Docs.
e.g.
A1= "Project A" link to Doc1
A2 = "Project A" link to Doc2
A3 = "Project A" link to Doc3
R
Rechie
I tried to insert text box but the hyperlink function is dimmed (not active).
D
Dave Peterson
Did you use the textbox from the Drawing toolbar?
Try right clicking on it once more by the edge.
But I'd use a rectangle from the drawing toolbar instead.
Try right clicking on it once more by the edge.
But I'd use a rectangle from the drawing toolbar instead.
J
Jon Peltier
Shapes do not have hyperlinks. But you can format the text to look like
hyperlinks, and assign a macro to each textbox/rectangle. The macro
needs this line of code:
ActiveWorkbook.FollowHyperlink sAddress
where sAddress is the address of the hyperlink.
- Jon
hyperlinks, and assign a macro to each textbox/rectangle. The macro
needs this line of code:
ActiveWorkbook.FollowHyperlink sAddress
where sAddress is the address of the hyperlink.
- Jon
D
Dave Peterson
Yes, assigning a macro would work, but so should assigning a hyperlink.
G
Gord Dibben
Try this.
Open only Doc1, Doc2, Doc3
Save As a workspace(*.resume.xlw) file then close.
Now hyperlink to that file through Insert>Hyperlink>Existing file or
webpage.
All three Docs will open from that one hyperlink.
Gord Dibben MS Excel MVP
Open only Doc1, Doc2, Doc3
Save As a workspace(*.resume.xlw) file then close.
Now hyperlink to that file through Insert>Hyperlink>Existing file or
webpage.
All three Docs will open from that one hyperlink.
Gord Dibben MS Excel MVP
G
Gord Dibben
Should have read save as workspace(*.xlw).
Excel will prompt with the default resume.xlw
Gord
Excel will prompt with the default resume.xlw
Gord
R
Rechie
The 3 docs are web page documents and I can not save it as .xlw
G
Gord Dibben
OK
You simply want to open 3 web page documents when you click on the
hyperlink?
How about you create a *.bat file to open the three docs?
Hyperlink to that *.bat file
Gord
You simply want to open 3 web page documents when you click on the
hyperlink?
How about you create a *.bat file to open the three docs?
Hyperlink to that *.bat file
Gord
J
Jon Peltier
Ah, I didn't realize a hyperlink can be assigned to a shape.
- Jon
- Jon