Learn how to a build a cloud-first strategyRegister Now

x
  • Status: Solved
  • Priority: Medium
  • Security: Public
  • Views: 349
  • Last Modified:

Putting a button on Excel ribbon (hyperlink)

Hi ,

I have 31 sheets in my workbook - one for each day of the month.

I have a table of contents sheet too which has 31 hyperlinks which act as a table of contents for each of the 31 sheets.  This works fine!

Question: How do I put a "Goto To Table OF Contents Sheet" button on the RIBBON.   I.e. I do not want to have to put this button on each of the 31 sheets.  I just want it on the "Ribbon" once!

Is this possible?
0
Patrick O'Dea
Asked:
Patrick O'Dea
  • 2
  • 2
2 Solutions
 
andrewssd3Commented:
This is not for the faint-hearted, but it's fine once you get it going.  This article gives you all the steps, the first of which is to download the Office Custom UI Editor http://msdn.microsoft.com/en-us/library/cc501317(v=office.11).aspx.  I can give you a step by step process once you have the custom ui editor
0
 
mark_harris231Commented:
What version of Excel are you using?  In 2007, you can add a macro to the Quick Access toolbar.  The following macro would work if you name the tab as "TableofContents" (or substitute your own sheet name and modify the macro):

Sub GoToTOC()
' GoToTOC Macro
' Keyboard Shortcut: Ctrl+Shift+T

    Sheets("TableofContents").Select
    Range("A1").Select
End Sub

You add the macro to the toolbar by right-clicking on the Ribbon and selecting Customize Quick Access Toolbar...  You then Macros from the drop-down and select your macro.
0
 
Patrick O'DeaAuthor Commented:
Ok Andrew, lets go for it !

 I have downloaded the Editor.
What next?

0
 
Patrick O'DeaAuthor Commented:
Andrew , I have tried Mark's solution and it works just as I want.
Thank you both!
0
 
andrewssd3Commented:
Sorry to leave you there - had to go to bed!  Glad you found a solution.  If you want to pursue the ribbon button, the article I referenced is comprehensive. A ribbon button is useful as it's embedded in the Excel file so helps if you are working on another machine or if you want to send your spreadsheet to someone else.
0

Featured Post

Upgrade your Question Security!

Add Premium security features to your question to ensure its privacy or anonymity. Learn more about your ability to control Question Security today.

  • 2
  • 2
Tackle projects and never again get stuck behind a technical roadblock.
Join Now