More than one Hyperlink for a single cell
 

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

More than one Hyperlink for a single cell
 

No, why do you want to do this?
--
If this helps, please click "Yes"
<<<<<<<<<<<


"Rechie" wrote:

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

More than one Hyperlink for a single cell
 

Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.

Pete

On Oct 26, 8:00*am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

More than one Hyperlink for a single cell
 

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" wrote:

Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.

Pete

On Oct 26, 8:00 am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

.

More than one Hyperlink for a single cell
 

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

On Oct 26, 11:20*am, Rechie wrote:
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" wrote:
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.

Pete

On Oct 26, 8:00 am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

.- Hide quoted text -

- Show quoted text -

More than one Hyperlink for a single cell
 

You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



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

More than one Hyperlink for a single cell
 

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

"Pete_UK" wrote:

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

On Oct 26, 11:20 am, Rechie wrote:
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" wrote:
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.

Pete

On Oct 26, 8:00 am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

.- Hide quoted text -

- Show quoted text -

.

More than one Hyperlink for a single cell
 

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


"Jon Peltier" wrote:

You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



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


.

More than one Hyperlink for a single cell
 

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.

Rechie wrote:

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

"Jon Peltier" wrote:

You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



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


.


--

Dave Peterson

More than one Hyperlink for a single cell
 

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



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


"Jon Peltier" wrote:

You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



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


.

More than one Hyperlink for a single cell
 

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

Jon Peltier wrote:

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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

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


"Jon Peltier" wrote:

You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



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


.


--

Dave Peterson

More than one Hyperlink for a single cell
 

Try this.

Open only Doc1, Doc2, Doc3

Save As a workspace(*.resume.xlw) file then close.

Now hyperlink to that file through InsertHyperlinkExisting file or
webpage.

All three Docs will open from that one hyperlink.


Gord Dibben MS Excel MVP

On Mon, 26 Oct 2009 07:59:01 -0700, Rechie
wrote:

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

"Pete_UK" wrote:

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

On Oct 26, 11:20 am, Rechie wrote:
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" wrote:
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.

Pete

On Oct 26, 8:00 am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

.- Hide quoted text -

- Show quoted text -

.

More than one Hyperlink for a single cell
 

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

Excel will prompt with the default resume.xlw


Gord

On Mon, 26 Oct 2009 09:50:35 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Try this.

Open only Doc1, Doc2, Doc3

Save As a workspace(*.resume.xlw) file then close.

Now hyperlink to that file through InsertHyperlinkExisting file or
webpage.

All three Docs will open from that one hyperlink.


Gord Dibben MS Excel MVP

On Mon, 26 Oct 2009 07:59:01 -0700, Rechie
wrote:

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

"Pete_UK" wrote:

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

On Oct 26, 11:20 am, Rechie wrote:
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" wrote:
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.

Pete

On Oct 26, 8:00 am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

.- Hide quoted text -

- Show quoted text -

.

More than one Hyperlink for a single cell
 

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



"Gord Dibben" wrote:

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

Excel will prompt with the default resume.xlw


Gord

On Mon, 26 Oct 2009 09:50:35 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Try this.

Open only Doc1, Doc2, Doc3

Save As a workspace(*.resume.xlw) file then close.

Now hyperlink to that file through InsertHyperlinkExisting file or
webpage.

All three Docs will open from that one hyperlink.


Gord Dibben MS Excel MVP

On Mon, 26 Oct 2009 07:59:01 -0700, Rechie
wrote:

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

"Pete_UK" wrote:

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

On Oct 26, 11:20 am, Rechie wrote:
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" wrote:
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.

Pete

On Oct 26, 8:00 am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

.- Hide quoted text -

- Show quoted text -

.


.

More than one Hyperlink for a single cell
 

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

On Mon, 26 Oct 2009 23:45:01 -0700, Rechie
wrote:

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



"Gord Dibben" wrote:

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

Excel will prompt with the default resume.xlw


Gord

On Mon, 26 Oct 2009 09:50:35 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Try this.

Open only Doc1, Doc2, Doc3

Save As a workspace(*.resume.xlw) file then close.

Now hyperlink to that file through InsertHyperlinkExisting file or
webpage.

All three Docs will open from that one hyperlink.


Gord Dibben MS Excel MVP

On Mon, 26 Oct 2009 07:59:01 -0700, Rechie
wrote:

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

"Pete_UK" wrote:

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

On Oct 26, 11:20 am, Rechie wrote:
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" wrote:
Well, you could have a hyperlink formula controlled by some IF
function. Give us some more details of what you want to achieve.

Pete

On Oct 26, 8:00 am, Rechie wrote:
Hi Experts,
Is it possible to have 3 hyperlinks in a single cell?
Thanks for your help.

.- Hide quoted text -

- Show quoted text -

.


.

More than one Hyperlink for a single cell
 

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

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



Dave Peterson wrote:
Yes, assigning a macro would work, but so should assigning a hyperlink.

Jon Peltier wrote:
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
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/

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


"Jon Peltier" wrote:

You could use three textboxes that fit over the cell. Each one should be
linked to a macro that follows a particular hyperlink.

- Jon
-------
Jon Peltier
Peltier Technical Services, Inc.
http://peltiertech.com/



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


.