Results 1 to 6 of 6
  1. #1
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Adding a button to a ribbon or toolbar (Excel 2007)

    In 2003 I created a custom button with text on my main toolbar that if I push automatically loads a favorite file. Is there a way of doing this in 2007??
    Thanks
    Jerome

  2. #2
    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

    Re: Adding a button to a ribbon or toolbar (Excel 2007)

    You can add buttons to the Quick Access Toolbar to run a macro fairly easily in 2007. You can also customise the Ribbon, but it's quite complicated.
    Regards,
    Rory

    Microsoft MVP - Excel

  3. #3
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Adding a button to a ribbon or toolbar (Excel 2007)

    Great, can you point me to detailed steps for both thanks Jerome

  4. #4
    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

    Re: Adding a button to a ribbon or toolbar (Excel 2007)

    QAT and Ribbon. Have fun with the latter! <img src=/S/grin.gif border=0 alt=grin width=15 height=15>
    Regards,
    Rory

    Microsoft MVP - Excel

  5. #5
    5 Star Lounger
    Join Date
    Aug 2001
    Location
    NY, NY, USA
    Posts
    654
    Thanks
    10
    Thanked 0 Times in 0 Posts

    Re: Adding a button to a ribbon or toolbar (Excel 2007)

    many many thanks
    Jerome

  6. #6
    Platinum Lounger
    Join Date
    Feb 2001
    Location
    Weert, Limburg, Netherlands
    Posts
    4,812
    Thanks
    0
    Thanked 0 Times in 0 Posts

    Re: Adding a button to a ribbon or toolbar (Excel 2007)

    In 2007 you can pin recently used files so they stay put (Spot the small pin next to the filename)
    Jan Karel Pieterse
    Microsoft Excel MVP, WMVP
    www.jkp-ads.com
    Professional Office Developers Association

Posting Permissions

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