Hyperlink view always in top unfrozen column

[Kra]

Hello!

I have a problem with hyperlinks. I have a huge data sheet so I need them to jump to specific column with month.

Buttons are in frozen columns A-B. Data sheet starts in column C:

First button (P01 2021) is linked to cell C1. It works fine. But second button (P01 2021) is linked to cell AE1. When I click it it displays this view:

I want it to display column AE in top left corner right after frozen columns AB. Is it possible?

 

[Kra]

Hello!

I have a problem with hyperlinks. I have a huge data sheet so I need them to jump to specific column with month.

Buttons are in frozen columns A-B. Data sheet starts in column C:


View attachment 68570


First button (P01 2021) is linked to cell C1. It works fine. But second button (P01 2021) is linked to cell AE1. When I click it it displays this view:

View attachment 68571

I want it to display column AE in top left corner right after frozen columns AB. Is it possible?

Edit: First button (P01 2021) is linked to cell C1. It works fine. But second button (P02 2021) is linked to cell AE1. When I click it it displays this view:

 

[FormR]

Hi, instead of using a hyperlink, you could assign a macro to your button, such as:

Sub JumptoAE1()
Application.Goto Range("AE1"), True
End Sub