Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
how to define target frame names for the hyperlinks in Excel
Veena,
Are you displaying this Excel file in IE or some browser? The hyperlinks from Excel actually are designed to open anything that is not Excel in an instance of the browser. Unfortunately it doesn't check for any other instance of the browser existing so it will open new links in new instances. Now if you are displaying the Excel file in a Web Page and are selecting the hyperlink from there you again will get a new window because you are functioning in a hosted session of Excel. But if you save the file as HTML you can actually edit the Hyperlink to point to a frame. Chris "veena" wrote in message ... Hi I am inserting hypelinks into excel sheet using the activesheet.hypelinks.add. however, every time i click on the url, it opens the destination url in a new window. i want to open it in the same window everytime it is click, which mean i will have to define the target name like we do in html and javascript. if anyone has any ideas as to how to do it, please let me know asap. thanks in advance, veena |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Define Range Names in Excel 2003-SP2 | Excel Discussion (Misc queries) | |||
Create/Edit Hyperlink - Unable to designate target frame | Excel Discussion (Misc queries) | |||
How do I find excel names that do not show in the define function | Excel Discussion (Misc queries) | |||
Enable target frame option | Excel Discussion (Misc queries) | |||
Define Names in Excel | Excel Discussion (Misc queries) |