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 |
All times are GMT +1. The time now is 04:53 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com