Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Open a hyperlink in a new page
Hi,
I am saving my excel worksheet which contains a hyperlink to a web site, as HTML. When I try to navigate to that link, it opens in the same page. I want it to open in a new page, and since there was no option for that when I created the hyperlink, I don't know how to solve it. (BTW, WORD has a "target frame" option). Any suggestions? Can it be done programmatically? Fixing the HTML file manually every save, is not an option. Thanks |
#2
|
|||
|
|||
Hi Yoav
You could try.... Sub test() ActiveWorkbook.FollowHyperlink Address:="http://news.bbc.co.uk/", _ NewWindow:=True End sub -- ----- XL2003 Regards William "Yoav" wrote in message ... Hi, I am saving my excel worksheet which contains a hyperlink to a web site, as HTML. When I try to navigate to that link, it opens in the same page. I want it to open in a new page, and since there was no option for that when I created the hyperlink, I don't know how to solve it. (BTW, WORD has a "target frame" option). Any suggestions? Can it be done programmatically? Fixing the HTML file manually every save, is not an option. Thanks |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
adding a new page break to an existing page break | Excel Discussion (Misc queries) | |||
hyperlink error: "Cannot open the specified file" | Excel Worksheet Functions | |||
Open page to row 1 instead of row 36 | Excel Discussion (Misc queries) | |||
How do I force a hyperlink in a spreadsheet to open a new window? | Excel Worksheet Functions | |||
open ended multi page sum | Excel Worksheet Functions |