Computing.Net > Forums > Office Software > hyperlink in new window/excel

Computer Problems? Computing.Net has over 1,000,000 posts about all things technology related! Over 90% answered within 24 hours! Click here to start participating now! Also, be sure to check out the New User Guide.

hyperlink in new window/excel

Reply to Message Icon

Name: mherber2
Date: August 2, 2008 at 10:55:30 Pacific
OS: xp pro
CPU/Ram: unknonw
Product: unknown
Comment:

im having a small issue but cannt find a fiw...i have a hyperlink in excel that always uses the same window. is there a setting in excel that i can change to cause it to open in a new window?



Sponsored Link
Ads by Google

Response Number 1
Name: seawatch
Date: August 3, 2008 at 08:41:10 Pacific
Reply:

If it's on your computer, I suggest you check your options under Internet Explorer to open a new window.

Larry

Coming home from very lonely places, all of us go a little mad: whether from great personal success, or just an all-night drive, we are the sole survivors of a world no one else has ever seen.
-


0

Response Number 2
Name: mherber2
Date: August 3, 2008 at 09:36:39 Pacific
Reply:

not on my computer...company computer, dont have access to internet options


0

Response Number 3
Name: Jennifer SUMN
Date: August 3, 2008 at 16:12:37 Pacific
Reply:

Where is the link pointing? A website? Another file? Another cell on the spreadsheet or workbook?

Life's more painless for the brainless.


0

Response Number 4
Name: mherber2
Date: August 4, 2008 at 13:33:28 Pacific
Reply:

web site


0

Response Number 5
Name: mherber2
Date: August 4, 2008 at 16:59:23 Pacific
Reply:

Well every one i have found a solution...
I knew it would be an easy one i just dont know why i didnt think of it sooner lol...

what i did is i began recording a new macro, created a hyperlink, right clicked and opened in new window, stopped macro recording. by doing so i got the fallowing code:

Selection.Hyperlinks.Follow NewWindow:=True, AddHistory:=True

threw the code in a private sub in the sheet containing the hyper link and every thing works great...lol took me 3 days to come up with that...thank you every one for your help


0

Related Posts

See More



Sponsored Link
Ads by Google
Reply to Message Icon

Excel - Difficult Formula Excel Macro Help: Is it e...



Post Locked

This post is quite old and has been locked from receiving new replies. Please create a new posting instead.


Go to Office Software Forum Home


Sponsored links

Ads by Google


Results for: hyperlink in new window/excel

Open in new window with hyperlinks www.computing.net/answers/office/open-in-new-window-with-hyperlinks/1913.html

hyperlink open in new window www.computing.net/answers/office/hyperlink-open-in-new-window/3302.html

Excel Opening hyperlink in Tab (I/E 8) www.computing.net/answers/office/excel-opening-hyperlink-in-tab-ie-8/9628.html