How to keep excel workbook opened

  • Thread starter Thread starter ComeMon!
  • Start date Start date
C

ComeMon!

Hi,

I have inserted several urls in one of my excel worksheet. However,
everytime I clicked on those urls, that corresponding workbook will be
closed although the associated document linked via the url can be
opened.

If I need to keep the workbook opened after I double clicked on the
url link, which excel setting do I need to change ?

:)
 
You can right-click and choose Open in New Window. However, the way a web
page forces a new window is done in html. Since I doubt you're saving as
html, that won't work. Otherwise, I believe it'll require code that you'd
apply to a button NEXT to the hyperlink, or put the hyperlink in a textbox
to which you can apply code. But you won't get it to work *normally*. If
you want to check the code method, I'd post in
microsoft.public.excel.programming

<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
Hope this helps!
Anne Troy (better known as Dreamboat)
Author: Dreamboat on Word
Email: Dreamboat*at*Piersontech.com
Web: www.TheOfficeExperts.com
<-*-><-*-><-*-><-*-><-*-><-*-><-*-><-*->
 
Anne Troy said:
You can right-click and choose Open in New Window.
Click to expand...

It works :)
However, the way a web
page forces a new window is done in html. Since I doubt you're saving as
html, that won't work.
Click to expand...

Sorry I missed detailed description. Actually I just added url links
in particular excel worksheet column. Every time I double click on any
of the url link defined in any cell, the workbook got closed at the
same time the html being opened.
Otherwise, I believe it'll require code that you'd
apply to a button NEXT to the hyperlink, or put the hyperlink in a textbox
to which you can apply code. But you won't get it to work *normally*. If
you want to check the code method, I'd post in
microsoft.public.excel.programming
Click to expand...

You mean that if I just insert url link in excel cell without extra
programming, there is no way to keep the workbook open while at the
same time open html file by double clicking on the url link ?
 
The below is correct. The only OTHER way is by changing a setting in IE or
Windows (not sure which you need). So, if it's for other people, you really
can't control it unless you're going to change everybody's settings. Try
going to IE, Tools-Internet options. Go to the advanced tab and uncheck
"reuse windows..."
 
Try changing a cell. (just make excel think the workbook needs saving)

Change it back right away. Now try clicking on the link.
 
Back
Top