For future searchers, as @fat fantasma mentioned, if a Hyperlink is attached to a shape, the VBA is never executed. Silly, but it's what we have to work with.

A workaround—still using VBA— is to place this line of code in whatever procedure is attached to run when the shape is clicked:

Application.Goto reference:=Range(<reference>), Scroll:=True

The window will place the reference in the top left (or thereabouts dependent upon freeze panes)

Note: you must remove the hyperlink attached to the shape. It seems it's presence causes the VBA block.