View Full Version : Excel hyperlink in new window?
Wonder84lalala
Oct 27, 2008, 09:09 AM
Any idea how to edit an hyperlink on Excel to open up in a new window? Thanks.
JBeaucaire
Oct 27, 2008, 10:23 AM
More info is needed, I suppose, since Hyperlinks in Excel DO open up a separate program unless they're hyperlinks to spots in the same spreadsheet.
Can you supply:
Version of Excel you're using
An example of WHAT the Hyperlink is linking to:
A section of the existing Excel spreadsheet
Sheet
Label
Defined Range
An email address
A web page/site
Everything listed above DOES open in a separate program/window except "section of the existing Excel Spreadsheet". Those hyperlinks jump you to the section.
mdosh01
Oct 28, 2008, 07:12 AM
With Excel 2003 and IE 7, links open in new tabs but not new windows. If you want a new window, it looks like you'll have to create a VB script per the following:
Hyperlink in Excel Viewed in Browser (http://techrepublic.com.com/5208-11192-0.html?forumID=42&threadID=166808&messageID=1705269)
"You will need to create a macro and then link a button to the macro. Try this code for the macro:
Sub Link()
ActiveWorkbook.FollowHyperlink Address:= _
"http://www.google.com/", NewWindow:= _
False, AddHistory:=True
Application.WindowState = xlNormal
End Sub
Then create a button in the spreadsheet and link it to that macro. This should open a new window with the url specified (change Google (http://www.google.com) to your desired url)."
Wonder84lalala
Oct 28, 2008, 09:11 AM
I have Excel 2003, and I want to edit the hyperlink target in Excel without using macro.
With HTML I can edit the target:
<a href="filename" target="_blank">
With hyperlink in Excel, can I do the same?
Thank you for your help though :-)
JBeaucaire
Oct 28, 2008, 10:24 AM
As previously asked, what "target" are you using? An email address? A web site? A spot in the current document? A separate but existing Excel doc?
Wonder84lalala
Oct 28, 2008, 11:48 AM
I'm targeting a separate but existing Excel doc (either save as .xls or .html).
Example:
=HYPERLINK("C:\Test\MyFile.xls","MyFile")
JBeaucaire
Oct 28, 2008, 12:20 PM
Ok, this needs to be fixed in your computer settings, not Excel.
Close Excel
Open My Computer
Go to Tools > Folder Options > File Types
Scroll down and choose XLS in the list of file types
Click on Advanced
Uncheck the Browse in same window box
In the Actions section, highlight Open
Click on Edit
Make sure in the Action box it says &Open
Make sure in the Application used to perform action it says:
"C:\Program Files\Microsoft Office\OFFICE11\EXCEL.EXE" "%1"
Check the box next to Use DDE
Remove anything that is in DDE Message box and DDE Application Not Running box
Make sure the Application box says: Excel
In the Topic box it says: System
Click on OK > OK > Apply/Close to save your changes.
You've just taught your computer to open every new file in a separate window, a separate instance of Excel.
Now open you file and click on a link to another file. It should open in another window. If you have Excel maximized, that might not be evident at first.
Wonder84lalala
Oct 29, 2008, 12:24 PM
Appreciated for your help, JB!
Thanks :D
mayavi555
Feb 26, 2013, 10:00 AM
here is my solution:
=HYPERLINK("javascript:window.open('www.google.com');void(0)", "New Window")