![]() |
Unable to add a hyperlink to a custom CammandBarButton
I'm trying to assign a hyperlink to a command bar button to
simply activate Sheet1. When trying Link to: Place in this document, I get messge "Internal hyperlinks are disabled in this mode." Is there a way to get around this? What mode is being referred to? win98 xl2002 |
Unable to add a hyperlink to a custom CammandBarButton
Can't say, but why not just assign a macro to the onaction property of the
commandbar button (or do it manually) Sub Button_Click() Application.Goto Reference:=ThisWorkbook. _ Worksheets("Sheet1").Range("A1"), Scroll:=True End Sub -- Regards, Tom Ogilvy Jay Fincannon wrote in message ... I'm trying to assign a hyperlink to a command bar button to simply activate Sheet1. When trying Link to: Place in this document, I get messge "Internal hyperlinks are disabled in this mode." Is there a way to get around this? What mode is being referred to? win98 xl2002 |
Unable to add a hyperlink to a custom CammandBarButton
Thank you too much Tom. Please excuse my tardiness in answering.
Jay Can't say, but why not just assign a macro to the onaction property of the commandbar button (or do it manually) Sub Button_Click() Application.Goto Reference:=ThisWorkbook. _ Worksheets("Sheet1").Range("A1"), Scroll:=True End Sub |
All times are GMT +1. The time now is 01:03 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com