LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
Art Art is offline
external usenet poster
 
Posts: 587
Default Target Frame

Asked this in another forum but no answer so trying here

First, thanks to this group for helping me with my
challenges.

I am publishing a spreadsheet through our intranet. I am
leaving it in XLS format rather than htm because the users
need to be able to save the sheet locally.

In one column I am using the command =hyperlink (a1) to
translate a text link from SQL to a real hyperlink. That
works very well (thanks group)

BUT..... How can I set the target frame reference in the
=hyperlink column so it opens a new window? I cannot seem
to open any command to make it open a new window. When
the user clicks on the link, it prompts them to save the
xls sheet.

Art

 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Create/Edit Hyperlink - Unable to designate target frame dch3 Excel Discussion (Misc queries) 2 November 14th 08 07:06 PM
Target cell reference moves when target is cut and pasted Illya Teideman Excel Discussion (Misc queries) 5 May 31st 07 11:34 AM
Enable target frame option Ian Excel Discussion (Misc queries) 0 April 6th 06 05:05 PM
How to attach legend frame to chart frame? holg3r Charts and Charting in Excel 2 July 7th 05 11:41 PM
how to define target frame names for the hyperlinks in Excel Chris Nicholas Excel Programming 0 July 10th 03 03:50 PM


All times are GMT +1. The time now is 11:00 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"