If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below. |
|
|
Thread Tools | Display Modes |
#1
|
|||
|
|||
Centering on image when link is clicked
Hello,
I have a simple workbook that consists of two worksheets, first with data and second with maps relating to that data. I have links throughout the first sheet that take the user to the second sheet, my problem being that these sometimes display with the linked cell near the bottom of the screen (causing a totally different map to be displayed in the center). Are there any ways to make the linked data display centered on the screen? |
#2
|
|||
|
|||
Centering on image when link is clicked
Hi Faerigirl,
You can set your link as a range. This will display the selected range on the displayable area. Eg if the map covers cells a1 to j10 set your link as a1:j10. This will 'select' the area between a1:j10 and assuming the map you want displayed is over that area, it will 'display' the map in the viewable area. The reason why sometimes the linked cell appears at the bottom/top of the page is that excel simply scrolls the worksheet up/down until the cell first appears in the viewable area and then it stops. " wrote: Hello, I have a simple workbook that consists of two worksheets, first with data and second with maps relating to that data. I have links throughout the first sheet that take the user to the second sheet, my problem being that these sometimes display with the linked cell near the bottom of the screen (causing a totally different map to be displayed in the center). Are there any ways to make the linked data display centered on the screen? |
Thread Tools | |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Thread Starter | Forum | Replies | Last Post |
How do I add a link to an image on my website to an e-mail | Trevdance | General Discussion | 2 | November 30th, 2005 03:55 PM |
Link to internet image from a form? | Mick | Using Forms | 2 | November 16th, 2005 12:23 PM |
Optional image vs. OLE | Brian | Using Forms | 5 | September 27th, 2005 02:52 AM |