Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 27,285
Default 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   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 23
Default 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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Unable to see custom Ad-Ins ribbon tab in Excel 2007 + Windows 7 JoeU in Texas Excel Worksheet Functions 0 January 11th 10 07:01 PM
Create/Edit Hyperlink - Unable to designate target frame dch3 Excel Discussion (Misc queries) 2 November 14th 08 07:06 PM
unable to edit or remove hyperlink from organisation chart Dave Excel Discussion (Misc queries) 0 September 20th 07 03:02 PM
unable to open a hyperlink Scott Hippauf Excel Discussion (Misc queries) 2 July 6th 07 01:12 PM
Unable to follow Hyperlink via keyboard Enter button Edmund Setting up and Configuration of Excel 1 July 4th 06 12:27 PM


All times are GMT +1. The time now is 02:44 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"