LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.newusers
twilliams
 
Posts: n/a
Default How to hyperlink to an image on a different sheet and display it f

I have 2 tabs, called "Sheet1" and "Sheet2". On "Sheet1", I have hundreds of
one line feature descriptions for my product. These descriptions are of
course text. On "Sheet2", I have inserted hundreds of screenshots of my
product. Now comes the fun part...

I created a hyperlink on the first line of text on "Sheet1" to link to a
cell just above the corresponding image on "Sheet2". When I click on the
hyperlink, I am taken to "Sheet2" and the cell i linked to is highlighted and
visible on the screen. The problem is that the cell is at the bottom of the
screen and the image I want to be displayed is below the bottom of the screen
and not visible.

I want whatever cell I hyperlink to, to be displayed at the Top of the
screen so that the image is fully on the screen every time, so that the user
just clicks a hyperlink and sees the corresponding image without having to
scroll up or down.

In HTML, browsers handle this automatically and display whatever you link to
at the top of the browser. Is there a way to ensure that whatever I link to
is moved to the same location (Top) every time?

Thanks in advance for any help i can get.
 
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
EXCEL UNPROTECT SHEET WILL NOT DISPLAY....HELP! JAN Excel Worksheet Functions 0 August 3rd 05 05:05 PM
Sheet display vrs. Print Preview Byron Excel Discussion (Misc queries) 4 July 6th 05 03:55 PM
How do I display data from multiple worksheets in a summary sheet. stardust Excel Discussion (Misc queries) 1 March 18th 05 12:26 PM
how to display formulas on the sheet flat6 Excel Worksheet Functions 8 February 18th 05 05:31 AM
hyperlink to specific sheet in excel mango Excel Worksheet Functions 1 December 9th 04 11:17 AM


All times are GMT +1. The time now is 08:28 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"