Hyperlink to top of section

G

George

I have set up a hyperlink at cell B2 in an Excel workbook to go to cell A1000
to view a table positioned at A1000:G1030. When I click on the hyperlink,
Excel goes to A1000, but A1000 appears at the bottom of the screen. So, I
have to hit PageDown to view the table. Is there a way to make A1000 appear
at the top of the screen, thus displaying the table?

Coding the hyperlink to go to A1030 is a weak solution. I want the cursor
at A1000 AND the table in view.

Thanks.
 
T

tjtjjtjt

Instead of a Hyperlink, you could do it with a very simple Macro.
One way:
1. Use the Control Toolbox to Draw a Commad Button over the top of cell B2.

2. Then, Double-Click on the Command Button.
Copy and paste this:

Application.Goto Reference:="R1030C1"
Range("A1000").Select

into the Private Sub CommandButton1_Click() macro, so that it looks like this:

Private Sub CommandButton1_Click()

Application.Goto Reference:="R1030C1"
Range("A1000").Select

End Sub


3. Back in Excel, you can turn off Design Mode by clicking the top left
button on the Control Toolbox.

4. Click the Button, and you should end up in A1000 with A1000 at the top of
your screen.

ou may have to adjust your macro security (Tools | Macros, Security) to
Medium to use this procedure in the future.
tj
 
Top