ActiveX button Hyperlink only works in design mode

[Kevin]

I've added an ActiveX button to a worksheet, selected it
and inserted a Hyperlink (to another sheet in the
workbook) and it works great - until you come out of
design mode. Any ideas/advice on how to make it work, or
get round it, other than getting rid of the button?

Cheers,

Kevin

 

[Dave Peterson]

Since it's a button, why not just have the code do the work:

Option Explicit
Private Sub CommandButton1_Click()
Application.Goto Worksheets("sheet3").Range("c1"), Scroll:=True
End Sub