Sean,

I don't know...it works for me. I modified the first hyperlink on the sheet
and uploaded it to my server. Give this a try:

http://longhead.com/temp/example.xls

If it works, you can do a save as and save it to your hard drive. Then you
can modify the other hyperlinks as explained below, and it should work. If
it doesn't work for you, I don't know what the problem would be.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


sq246 wrote:
Jake

I tried what you suggested but it still tried to go to the link on
the same page thereby losing my excel!

Help!

Sean

"Jake Marx" wrote:

Hi Sean,

The only thing I can think of is to use the FollowHyperlink event to
trap the click on the hyperlink. To do this, however, would force
the "enable macros?" popup, which you may not want.

If you don't care about that, you can do as follows:

1) In cell B10, change the formula to =Z10.

2) Right-click B10 and select Hyperlink. Click the "Place in This
Document" button on the left, select Sheet1, and type B10 in the
cell reference box.

3) Right-click the worksheet tab at the bottom of the screen and
paste the following into the resulting code pane:

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
ThisWorkbook.FollowHyperlink Address:="http://bigcharts." & _
"marke****ch.com/quickchart/quickchart.asp?symb=" & _
UCase$(Target.Parent.Value), NewWindow:=True
End Sub

4) Follow steps 1-3 for each hyperlink.

--
Regards,

Jake Marx
MS MVP - Excel
www.longhead.com

[please keep replies in the newsgroup - email address unmonitored]


sq246 wrote:
Ron

Sorry that doesn't work! If you go to www.regentfinancial.net and
select the page tiltled The Market Scan Report and then click on the
link to see an example market scan report you will have an excel
file open. Within that file are hyperlinks, clicking on any of
those hyperlinks causes the excel file to try to close. I need to
find a way of making those hyperlinks open a new window rather than
try to close excel to go to the link URL.

Sean

"Ron de Bruin" wrote:

Hi Sean

Try Shift -Click

--
Regards Ron de Bruin
http://www.rondebruin.nl



"sq246" wrote in message
...
Hi

I am using Excel from Office 2003. I am uploading an excel file
to a website so the .xls file opens in a browser window. The
excel file contains hyperlinks. When teh user clicks on the
hyperlinks, they try to open in the same window, thereby shutting
down the excel programme - how can I force the hyperlink to open
a new browser window?

Urgent help needed!!

Thanks

Sean