![]() |
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. |
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