+ Reply to Thread
Results 1 to 5 of 5

Editing an existing Add-In Ribbon

  1. 03-28-2015, 11:32 PM #1
    Todd192
    Todd192 is offline
    Registered User
    Join Date
    05-08-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    7

    Editing an existing Add-In Ribbon

    I am working on a project in Word 2010 but am very much a beginner. The details of the project don't matter too much but I have re-written and re-designed the macros within the document. The previous designer made an Add-In Ribbon where you could choose to run the Macros by clicking one of the buttons therein. I cannot work out how this is done and cannot change these items so they have different titles and different targets

    AddIn.png

    I only seem to be able to delete these buttons or the whole Ribbon but nothing more useful.

    Is anyone able to help?

    Thanks
    Alex
    Last edited by Todd192; 03-29-2015 at 08:32 PM.
    Reply With QuoteRegister To Reply
  2. 03-29-2015, 08:31 PM #2
    Todd192
    Todd192 is offline
    Registered User
    Join Date
    05-08-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Editing an existing Add-In Ribbon

    Ok so I spent some time working on this issue today and found the below which I believe to be the route of the ToolBar design

    attachedToolbars.png

    Is this correct? What programme can I use to edit this file to add the right paths, etc to the Add-Ins Menu?

    Thanks again
    Alex
    Reply With QuoteRegister To Reply
  3. 03-29-2015, 09:42 PM #3
    MarvinP
    MarvinP is offline
    Forum Guru MarvinP's Avatar
    Join Date
    07-23-2010
    Location
    Woodinville, WA
    MS-Off Ver
    Office 365
    Posts
    16,165

    Re: Editing an existing Add-In Ribbon

    Hi Todd,

    Did you look at customizing the ribbon at: http://www.excel-easy.com/basics/ribbon.html

    I think all ribbon function are set using the above info. You can create custom functions and add them also to the ribbon using the above site methods.
    One test is worth a thousand opinions.
    Click the * Add Reputation below to say thanks.
    Reply With QuoteRegister To Reply
  4. 03-30-2015, 08:40 AM #4
    Todd192
    Todd192 is offline
    Registered User
    Join Date
    05-08-2013
    Location
    Singapore
    MS-Off Ver
    Excel 2010
    Posts
    7

    Re: Editing an existing Add-In Ribbon

    Thanks Marvin. I think this link is a little simpler than what I was hoping to do.

    I want about 20 macro shortcuts to sit on the Ribbon for all users only when they open this document. The issue is that I am picking through another persons previous work and they had clearly used the method I am investigating. It seems clear to me (but I am a novice!) that I need to amend the attachedToolbars.bat file to amend the buttons on the Add-In Ribbon that has been designed but I don't know how. Is this correct and are there any free program where I can easily amend this file?
    Reply With QuoteRegister To Reply
  5. 04-17-2015, 09:34 PM #5
    CaptMac
    CaptMac is offline
    Forum Contributor
    Join Date
    10-02-2008
    Location
    Berkeley, CA
    MS-Off Ver
    Windows 2007
    Posts
    105

    Re: Editing an existing Add-In Ribbon

    So here is a very good set of Ribbon Information:
    Ron de Bruin's "Ribbon Examples files and Tips"

    Good luck. There's lots to learn. But he has lots of examples of different ways to handle ribbons stuff as well. He's been my God send.

    Mac
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next Thread »

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Similar Threads

  1. Help with editing an existing VBA
    By Navin Agrawal in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 09-05-2013, 03:29 AM
  2. [SOLVED] Ribbon Edit the existing file
    By marreco in forum Excel Programming / VBA / Macros
    Replies: 12
    Last Post: 07-13-2012, 07:56 PM
  3. Editing existing Macro
    By jsheppard in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-11-2010, 12:11 AM
  4. How can i add a button to existing ribbon
    By J.wills in forum Outlook Programming / VBA / Macros
    Replies: 1
    Last Post: 03-30-2009, 02:41 AM
  5. Editing an existing formula
    By Jen in forum Excel Formulas & Functions
    Replies: 1
    Last Post: 10-24-2005, 03:05 PM

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1