Hide hyperlink cell & replace with macros

J

Jose

I have created an excel spreadsheet with a hyperlink in a cell. I would like
to replace the hyperlink with a [Button] to hide the hyperlink and only show
the i.e [GO TO] button.

Is this possible if so what are the steps?

Thanks you for your time.
 
H

hui

Sub Button1_Click()
Call Macro1
End Sub
Sub Macro1()
'I suppose you have put a hyperlink on Cell E8
Range("E8").Select
Selection.Hyperlinks(1).Follow NewWindow:=False, AddHistory:=True
Application.WindowState = xlNormal
End Sub
 
Top