ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)
-   -   Hide hyperlink cell & replace with macros (https://www.excelbanter.com/excel-worksheet-functions/12773-hide-hyperlink-cell-replace-macros.html)

Jose

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.


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

"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.





All times are GMT +1. The time now is 01:47 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com