Jumping to another part of a spreadsheet by clicking a word

Hello,

I'm wondering if anybody could help me with this, please. I'm trying to make it so that when you click a word (for example, "June"), it brings you to that part of the spreadsheet (starts at A30, if you take June as an example).

I tried using a hyperlink but all that does is select the cell A30 instead of moving down to it.

Many thanks in advance.

What's the difference between "selecting a cell" and "moving down to it"?

Note: If you are hoping that the hyperlinked cell will be positioned
in the upper left of the worksheet window, you'll need VBA code to effect that.

Guess you could save a custom view if you wanted to avoid a macro

VBA Noob

With code it would look like

Please Login or Register  to view this content.

VBA Noob

If you're specific about your hyperlinks....then you could engage the
Hyperlink.Follow event to position the referenced cell in the upper left.

Here's how:
• Right-click the sheet tab
• Select: View Code
That will bring you to the Visual Basic Editor (VBE) code module for that sheet
• Copy the below code and paste it into the VBE module

Please Login or Register  to view this content.

Now...whenever you click a hyperlink on that sheet, the target cell will be
positioned in the upper left.

Is that something you can work with?

If you are satisfied with the solution(s) provided, please mark your thread as Solved.

How to mark a thread Solved
Go to the first post
Click edit
Click Go Advanced
Just below the word Title you will see a dropdown with the word No prefix.
Change to Solved
Click Save