ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Open hyperlink in new window (https://www.excelbanter.com/excel-programming/308668-open-hyperlink-new-window.html)

mleonard

Open hyperlink in new window
 
I'm working with an Excel file that is saved at an HTML and used on a
website. I have a few thumbnail pictures within the spreadsheet which
hyperlink to a larger version of the picture. I would like the
hyperlink to open in a new window but cannot figure it out. Adding
"_blank" after the target .JPG would make sense, but it continues to
open in the same window. Any suggestions?

If this is not possible, is it possible to set the background color of
..JPG hyperlink? Thanks. - Mike

GJones

Open hyperlink in new window
 
Hi Mike;

Use the hyperlink in the Excel sheet to send a parameter
to an ASP page that will inturn go get the larger image.
Something like this;

Http://MyReferringPage.asp?MyPicture=BigMikePicture.jpg


Then create an ASP Page that loads the image. The asp
code would look something like this;

<img border="0" src=<%Request("MyPicture")%


Thanks,

Greg


-----Original Message-----
I'm working with an Excel file that is saved at an HTML

and used on a
website. I have a few thumbnail pictures within the

spreadsheet which
hyperlink to a larger version of the picture. I would

like the
hyperlink to open in a new window but cannot figure it

out. Adding
"_blank" after the target .JPG would make sense, but it

continues to
open in the same window. Any suggestions?

If this is not possible, is it possible to set the

background color of
..JPG hyperlink? Thanks. - Mike
.



All times are GMT +1. The time now is 09:00 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com