Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink
How do I get the worksheet to place the hyperlinked target cell in the A1
position, when I jump to the section I want on a computer with a smaller screen I loose the left/upper area-- Carl in Vegas |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
hyperlink
Hi Carl:
This may belp. Let's say we have a hyperlink in cell A1 that takes us to cell Z100. Insert this tiny Event macro in the Worksheet code area: Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink) Dim s As String s = ActiveCell.Address(ReferenceStyle:=xlR1C1) Application.Goto Reference:=s, Scroll:=True End Sub After installing this, hyperlink jumps will go to the correct cell and that cell will be positioned in the upper left-hand corner (the A1 position). REMEMBER: the worksheet code area, not a standard module. -- Gary''s Student - gsnu200743 "Carl" wrote: How do I get the worksheet to place the hyperlinked target cell in the A1 position, when I jump to the section I want on a computer with a smaller screen I loose the left/upper area-- Carl in Vegas |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Can't make hyperlink function work for hyperlink to website | Excel Worksheet Functions | |||
How do I create a hyperlink to a cell with the hyperlink function | Excel Worksheet Functions | |||
Moving rows with Hyperlink doesn't move hyperlink address | Excel Discussion (Misc queries) | |||
Hyperlink from one sheet to the hyperlink on another | Excel Discussion (Misc queries) | |||
Intra-workbook hyperlink: macro/function to return to hyperlink ce | Excel Discussion (Misc queries) |