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
"Jose" wrote in message
...
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.
|