Putting a button on Excel ribbon (hyperlink)

Posted on 2011-10-27
Last Modified: 2012-05-12
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?
Question by:Patrick O'Dea
    LVL 17

    Assisted Solution

    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  I can give you a step by step process once you have the custom ui editor
    LVL 10

    Accepted Solution

    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

    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.

    Author Comment

    by:Patrick O'Dea
    Ok Andrew, lets go for it !

     I have downloaded the Editor.
    What next?


    Author Closing Comment

    by:Patrick O'Dea
    Andrew , I have tried Mark's solution and it works just as I want.
    Thank you both!
    LVL 17

    Expert Comment

    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.

    Write Comment

    Please enter a first name

    Please enter a last name

    We will never share this with anyone.

    Featured Post

    IT, Stop Being Called Into Every Meeting

    Highfive is so simple that setting up every meeting room takes just minutes and every employee will be able to start or join a call from any room with ease. Never be called into a meeting just to get it started again. This is how video conferencing should work!

    Dealing with unintended Excel Active-X resizing quirks (VBA code simulates "self correction") David Miller (dlmille) Intro Not everyone is a fan of Active-X controls in spreadsheets (as opposed to the UserForm approach, the older Form controls …
    How to quickly and accurately populate Word documents with Excel data, charts and images (including Automated Bookmark generation) David Miller (dlmille) Synopsis In this article you’ll learn how to use ExcelToWord! to copy data,charts, shapes …
    This Micro Tutorial demonstrates in Microsoft Excel how to consolidate your marketing data by creating an interactive charts using form controls. This creates cool drop-downs for viewers of your chart to choose from.
    This Micro Tutorial will demonstrate how to use a scrolling table in Microsoft Excel using the INDEX function.

    758 members asked questions and received personalized solutions in the past 7 days.

    Join the community of 500,000 technology professionals and ask your questions.

    Join & Ask a Question

    Need Help in Real-Time?

    Connect with top rated Experts

    10 Experts available now in Live!

    Get 1:1 Help Now