Results 1 to 5 of 5
  1. #1
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    409
    Thanks
    37
    Thanked 5 Times in 5 Posts

    Transferability of User Added Buttons

    If I write a macro, and install a control for it in my spreadsheet, that control will show up and run the macro if I send the file to someone else.

    But, I'm having trouble doing the same thing when I add a button to my ribbon. Is that in my personal.xlsb file, so it doesn't transfer with a file?

    Is there a way to transfer a file to someone else with my ribbon buttons?

  2. #2
    5 Star Lounger
    Join Date
    Jan 2004
    Location
    Praha
    Posts
    988
    Thanks
    56
    Thanked 105 Times in 90 Posts
    There is a very helpful article on the Ribbon here: http://datapigtechnologies.com/blog/...izable-ribbon/

    Just over half way down . . . "Exporting Customisations will create an .exportedUI file that you can use to share your customisations with others, or transfer your customisations to another computer . . . ." explains how to export (and then import) your Ribbon customisations.

    PS For users of American English, subsititute customization for customisation

  3. #3
    4 Star Lounger
    Join Date
    Jun 2003
    Location
    Utah, USA
    Posts
    409
    Thanks
    37
    Thanked 5 Times in 5 Posts
    Thanks. Yes, this seems to do what I need. Not very convenient for sharing though ...

  4. #4
    Gold Lounger Maudibe's Avatar
    Join Date
    Aug 2010
    Location
    Pa, USA
    Posts
    2,637
    Thanks
    115
    Thanked 650 Times in 592 Posts
    boo,

    Take a look here. You can add additional code to write new menus, buttons, etc. that will change the ribbon on the fly when the user opens the workbook then back again when it closes. This was much easier done in 2003, however, it still looks very doable.

    HTH,
    Maud

  5. #5
    WS Lounge VIP rory's Avatar
    Join Date
    Dec 2000
    Location
    Burwash, East Sussex, United Kingdom
    Posts
    6,280
    Thanks
    3
    Thanked 191 Times in 177 Posts
    If you want workbook-specific Ribbon changes, I suggest you read through Ron's site here: http://www.rondebruin.nl/win/s2/win001.htm
    Also, Andy Pope has a free customising add-in here: http://www.andypope.info/vba/ribboneditor_2010.htm
    Regards,
    Rory

    Microsoft MVP - Excel

Posting Permissions

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