+ Reply to Thread
Results 1 to 3 of 3

Had custom toolbar in older Excel for Mac, seeking similar functionality in Excel 2016

  1. #1
    Registered User
    Join Date
    10-12-2013
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    36

    Question Had custom toolbar in older Excel for Mac, seeking similar functionality in Excel 2016

    I have a custom app in the form of a workbook with multiple sheets which are reconfigured on the fly by an extensive macro suite. Users have always triggered macros as needed with a single click in my custom toolbar, which is automatically loaded when the workbook is opened. (The toolbar has around 25 customised buttons.) This has worked just fine in every version of Excel for over 15 years, but Excel 2016 drops support for custom toolbars entirely.

    As far as I can make out, in Excel 2016 macros can only be triggered by -
    (a) selecting from the list in Tools > Macros and then clicking Run OR
    (b) associating the macros with worksheet objects (buttons/shapes/textboxes/etc) which are clicked by the user OR
    (c) using keyboard shortcuts.

    These options do not work for me because:
    (a) is far too cumbersome - users sometimes need to click several of my toolbar buttons per minute,
    (b) hides the triggering objects from users most of the time: they need to be able trigger any macro instantly, no matter which worksheet they are on and no matter how the active worksheet is scrolled,
    (c) users would need to memorise 25+ keyboard shortcuts!

    In the absence of a custom toolbar, the only way I can see to make ALL the macros ALWAYS available (no matter what part of the workbook users are looking at) is to
    (a) duplicate the trigger objects onto every sheet of the workbook and
    (b) place them all in a non-scrolling pane on each worksheet.
    But even this doesn't really solve my problem, because I already use small non-scrolling panes to show running totals and to show current workbook status.

    Any ideas? (Apart from cursing the Excel development team for their Ribbon obsession.)
    BTW, I develop in Excel for Mac, and all my users also run Mac Excel, but this issue is common to Mac and Windows.
    Last edited by ianpage; 05-12-2016 at 07:15 PM.

  2. #2
    Forum Expert rorya's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365 Ent Monthly Channel / Insiders Beta
    Posts
    8,908

    Re: Had custom toolbar in older Excel for Mac, seeking similar functionality in Excel 2016

    You can modify the Ribbon to add your own controls in Excel 2016 (Mac and PC): http://www.rondebruin.nl/mac/section8.htm

  3. #3
    Registered User
    Join Date
    10-12-2013
    Location
    Seattle, USA
    MS-Off Ver
    Excel 2011 for Mac
    Posts
    36

    Re: Had custom toolbar in older Excel for Mac, seeking similar functionality in Excel 2016

    Wow! Thanks Rorya! This is the first glimmer of light I've had since Mac Excel 2016 was released. I'm no VBA expert, but you can bet I'll be upping my skills and working hard to pursue this very welcome option!

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Similar Threads

  1. Why won't Excel 2016 display my custom ribbon?
    By rkjudy in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 12-05-2015, 04:20 PM
  2. Add toolbar button for custom formatting - Excel 2013
    By mateoc15 in forum Excel General
    Replies: 1
    Last Post: 08-06-2014, 09:43 AM
  3. Excel Add-In: how to position custom toolbar
    By elarsen in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-27-2007, 12:52 AM
  4. Excel Custom Made Toolbar
    By drawlings in forum Excel Programming / VBA / Macros
    Replies: 7
    Last Post: 08-16-2006, 02:25 PM
  5. [SOLVED] Removing custom toolbar from Excel 2003
    By [email protected] in forum Excel General
    Replies: 0
    Last Post: 07-14-2006, 12:05 PM
  6. SOS: Excel custom Toolbar
    By hedonists in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 01-12-2006, 11:20 AM

Tags for this Thread

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

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1