More than one Hyperlink for a single cell

[Rechie]

Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

 

[BSc Chem Eng Rick]

No, why do you want to do this?

 

[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

 

[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 .

 

[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

 

[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

 

[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

 

[Rechie]

I tried to insert text box but the hyperlink function is dimmed (not active).

 

[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.

 

[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

 

[Dave Peterson]

Yes, assigning a macro would work, but so should assigning a hyperlink.

 

[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

 

[Gord Dibben]

Should have read save as workspace(*.xlw).

Excel will prompt with the default resume.xlw


Gord

 

[Rechie]

The 3 docs are web page documents and I can not save it as .xlw

 

[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

 

[Jon Peltier]

Ah, I didn't realize a hyperlink can be assigned to a shape.

- Jon