Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Unable to see custom Ad-Ins ribbon tab in Excel 2007 + Windows 7 | Excel Worksheet Functions | |||
Create/Edit Hyperlink - Unable to designate target frame | Excel Discussion (Misc queries) | |||
unable to edit or remove hyperlink from organisation chart | Excel Discussion (Misc queries) | |||
unable to open a hyperlink | Excel Discussion (Misc queries) | |||
Unable to follow Hyperlink via keyboard Enter button | Setting up and Configuration of Excel |