Results 1 to 8 of 8
  1. #1
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Making macro toolbars available in 2007 (Excel 2007)

    Eeek!
    Just converted to Office 2007 and my custom toolbars and custom menu items (which I had come to rely on for speed and efficiency in Excel 2003) don't work, and don't appear to be editable! Is it possible to create some custom toolset in Excel 2007 where I can make my many macros readily available again? Can someone point me to some worthy references?

    Mahalo,

    John Jacobson

  2. #2
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Making macro toolbars available in 2007 (Excel 2007)

    You can use the Quick Access Toolbar. See Reference: Locations of Excel 2003 commands in Excel 2007.

  3. #3
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Making macro toolbars available in 2007 (Excel 2007)

    Thanks Hans,
    I started down that road, but I have at least 20 macros that I would add right away, which makes for a rather cluttered Quick Access toolbar. Additionally I had a couple of custom toolbars that i used specifically for editing data from certain sources, where I would make the toolbar visible only when I was editing such data. So there's no easy way to add groups to the ribbon, or add a custom menu tab?

    Aloha,
    John Jacobson

  4. #4
    Plutonium Lounger
    Join Date
    Mar 2002
    Posts
    84,353
    Thanks
    0
    Thanked 29 Times in 29 Posts

    Re: Making macro toolbars available in 2007 (Excel 2007)

    It's possible to customize the Ribbon, but it's more complicated than customizing toolbars. See Change the ribbon in Excel 2007.

  5. #5
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Making macro toolbars available in 2007 (Excel 2007)

    <!profile=Pieterse>Pieterse<!/profile> has a website that deals with this type of query. See : http://www.jkp-ads.com/articles/DistributeMacro04.htm, esp. at the bottom of the page where he deals with Excel 2007. Also click on the previous link to get more detail on customising the ribbon to add a group. I'm sure you could get more details directly from him when he is back on-line again!
    Regards,
    Rudi

  6. #6
    Gold Lounger
    Join Date
    Feb 2004
    Location
    Cape Town, RSA
    Posts
    3,444
    Thanks
    0
    Thanked 1 Time in 1 Post

    Re: Making macro toolbars available in 2007 (Excel 2007)

    Nice link there. TX (I'll be studying this more at a later point!)
    Regards,
    Rudi

  7. #7
    Star Lounger
    Join Date
    Sep 2002
    Location
    Honolulu, Hawaii, USA
    Posts
    63
    Thanks
    1
    Thanked 0 Times in 0 Posts

    Re: Making macro toolbars available in 2007 (Excel 2007)

    Thanks Hans and Rudi!
    These last 2 links are more than enough to keep me busy for now. What a grand adventure! I'm sure my needs will change as I become more familiar with the new locations of certain commands and the keyboard shortcuts to access them, as several of my handy macros were just one-step means of accomplishing what would take 4 or 5 steps in the 2003 menu system.

    Bonne Année 2008 à tout, or in my favorite translation Hippie Nude Beer,
    John Jacobson

  8. #8
    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: Making macro toolbars available in 2007 (Excel 2007)

    Your custom toolbars should all appear on the add-ins tab. Changes made to the right-click shortcut menus seem, for the most part, to work as they did.
    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
  •