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.
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.
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" <[email protected]> wrote in message
news:[email protected]...
> 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.
>
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks