Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - hyperlink to a location in the same file
When I create a hyperlink to a location within the same Excel 2003 file, it
goes to that location, but often, the location appears at the bottom of the screen and then I have to scroll down to see the rest of the information below the hyperlink. Is there a way to have the hyperlinked location automatically appear at the top of the Excel screen when you hyperlink to it? |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2003 - hyperlink to a location in the same file
Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
With ActiveWindow .ScrollRow = ActiveCell.Row .ScrollColumn = ActiveCell.Column End With End Sub This is sheet event code. Right-click on the sheet tab and "View Code". Copy/paste the code into that module. A click on a hyperlink will bring the destination cell to top left of sheet. Gord Dibben MS Excel MVP On Mon, 29 Jun 2009 08:08:01 -0700, Silverstreak wrote: When I create a hyperlink to a location within the same Excel 2003 file, it goes to that location, but often, the location appears at the bottom of the screen and then I have to scroll down to see the rest of the information below the hyperlink. Is there a way to have the hyperlinked location automatically appear at the top of the Excel screen when you hyperlink to it? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Default File Location-Excel 2003 | Excel Discussion (Misc queries) | |||
Excel 2003 default file location | Excel Discussion (Misc queries) | |||
File Location Hyperlink | Setting up and Configuration of Excel | |||
Excel 2003: cannot locate default file location | Excel Discussion (Misc queries) | |||
Excel 2003: cannot find default file location | Excel Discussion (Misc queries) |