View Single Post
  #10   Report Post  
Posted to microsoft.public.excel.programming
NickHK NickHK is offline
external usenet poster
 
Posts: 4,391
Default How do I force a browser based excel hyperlink to open a new w

Sean,
It also on the user's browser and its settings.
I use Opera and this opens in an instance of Excel. Clicking a hyper link
opens the page in a new page of the Opera instance.

Not sure if this your desired behaviour.

NickHK


"sq246" wrote in message
...
Ron

It is vital that this works from the web server as part of the spreadsheet
updates every minute so saving to hard drive wouldn't be acceptable.

There
must be some form of code that could be put in which would make the
hyperlinks open a new window.

Sean

"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