Hyper link help

[garydaw]

Hyer link help

I am designing a spreadsheet. My sheet is very wide by design. I want to make hyper links to jump to the section of the page I want to see. I need the section to “jump” to the far left side of the program screen not to the middle of the screen. I installed Hyper links on my spreadsheet when I click to them, the section of the page shows up in the middle of the screen. How do I make this happen?


Thanks

Gary

[Leith Ross]

Hello Garydaw,

You need to create a macro to scroll side to side and up and down. Here is an example that will put the cell you choose in the Top Left corner. You can change the Row and Column to match where you want to move the worksheet. This example puts cell AV15 in the top left corner.

Sub PositionWorksheet()

  Dim C As Long, R As Long
  Dim CellAddress As String
  Dim Wks As Worksheet

    CellAddress = "AV15"

    Set Wks = ActiveSheet
      With Wks.Range(CellAddress)
         C = .Column
         R = .Row
      End With
    
    With ActiveWindow
       .ScrollColumn = C
       .ScrollRow = R
    End With

End Sub

You can place buttons on your worksheet then attach this macro to them. Just be sure to copy the macro, give it a different name, and change the address before assigning it to another button to position the worksheet.

Sincerely,
Leith Ross

[garydaw]

Leith,

Unless you can give me instructions on how to do this I am lost. This is way over my head... I tried to figure it out, I seriously don't have a clue to where and how to start..... Is there a simple way to do this?

Thanks,

Gary

[davesexcel]

This could work


on the sheet with the hyperlink
right click on the sheet tab and select view codes

copy and paste this code in the area

Private Sub Worksheet_FollowHyperlink(ByVal Target As Hyperlink)
    ActiveWindow.ScrollColumn = ActiveCell.Column

End Sub