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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top