multiple URLS in one cell

madams2

New Member
Joined
Oct 28, 2005
Messages
1
I have a calendar with events in it for each day (1 day per cell). If 1 day has 5 events I would like to be able to allow each event to be a different hyperlink. When I try it, I can only create one hyperlink. Is this possible?
 

Excel Facts

Format cells as currency
Select range and press Ctrl+Shift+4 to format cells as currency. (Shift 4 is the $ sign).
No; you can only have 1 hyperlink in a cell.

Edit: This is referring to links added using Insert\Hyperlink.
 
Upvote 0
It is indeed impossible to place more than one hyperlink inside a single cell.

A workaround to make it *look* like more than one hyperlink exists in a cell is to place (in your case) 5 separate transparent activeX label controls onto a cell, each with their respective caption, and each whose Click event will take you to the destination that the respective hyperlink would have. You can also manipulate the label's properties to make the text color blue, and underlined, so it will look to some people like 5 hyperlinks actually exist in the cell, though really they are none but all on transparent activex labels embedded in the cell.
 
Upvote 0

Forum statistics

Threads
1,219,162
Messages
6,146,659
Members
450,706
Latest member
LGVBPP

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top