ActiveX button Hyperlink only works in design mode

  • Thread starter Thread starter Kevin
  • Start date Start date
K

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
 
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
 
Back
Top