Opening Hytperlink - A New Twist

**Launchnet** · 03-18-2008, 02:27 PM

Good Morning Everyone . . .

I have an interesting application.

For easy explanation . . . My workbook consists of two sheets (Sheet1 & Sheet2)

THE USER CAN NOT CHANGE SHEET1 AS IT IS PROTECTED.

SHEET2 IS NOT PROTECTED AND THE USER CAN MAKE CHANGES AND ADDITIONS.

On sheet2 . . . Cell A1 . . . I want the user to type in any Hyperlink such as: www.ebay.com Then, I want the user to change the Hyperlink name to "Open eBay" At this point all is well and good.

Now, back to sheet1 . . . Cell A1 . . . I want Cell A1 to display the Hyperlink name "Open eBay" from sheet2 . . . Cell A1 . . . just as if I had connected the two together using the = syntax.

Here lies my problem:

When sheet1 is displayed, I want the user to be able to click the words "Open eBay" in cell A1 and have the Hyperlink on sheet2 @ cell A1 activate and open eBay.

Then, if this Hyperlink on sheet2 . . . Cell A1 . . . is changed to a different Hyperlink, sheet1 is also automatically changed and clicking it will open the new Hyperlink.

Additionally, if I had more Hyperlinks, I would want different cells to open different Hyperlinks from whatever cell I chose to use.

Hope this makes sence.

Thanks - Launchnet

**Leith Ross** · 03-18-2008, 02:46 PM

Hello Lauchnet,

Please do not bold your entire post, only words that need emphases. Bolding all your text in post is like shouting in a conversation, especially when capitalized.

Sincerely,
Leith Ross

**Launchnet** · 03-18-2008, 02:51 PM

Thanks for the input. I won't any more.
Launchnet

**Leith Ross** · 03-19-2008, 01:41 AM

Hello Launchnet,

Please read the rules about cross posting. It is allowed in the forum provided you add a link to or mention where you have cross posted.

Your other post is here...
microsoft.public.excel.programming

Sincerely,
Leith Ross

**Launchnet** · 03-19-2008, 12:11 PM

Good to know.

I wasn't aware that I should not post in other forums without stating that I have or adding a link.

For linking, can I use the URL to the 2nd posting ?

How to I find the information about cross posting. I can't see any place to look it up.

Thanks, I always want to abide by the rules.

Launchnet