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