ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Unable to add a hyperlink to a custom CammandBarButton (https://www.excelbanter.com/excel-programming/285424-unable-add-hyperlink-custom-cammandbarbutton.html)

Jay Fincannon

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

Tom Ogilvy

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




Jay Fincannon

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