Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Hide hyperlink cell & replace with macros
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. |
#2
|
|||
|
|||
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. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Hyperlink within cell | Excel Discussion (Misc queries) | |||
Hide text that doesn't fit in the cell | Excel Discussion (Misc queries) | |||
how to hyperlink text to a cell | New Users to Excel | |||
Using a formula in a Hyperlink Cell reference | Excel Discussion (Misc queries) | |||
GET.CELL | Excel Worksheet Functions |