+ Reply to Thread
Results 1 to 4 of 4

Adding a personal drop-down option on the Quick Access Toolbar

  1. #1
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    Adding a personal drop-down option on the Quick Access Toolbar

    Hi,

    I have several macros that I have added to the Quick Access Toolbar for ease of use.
    Each of these buttons are individual so making my Quick Access toolbar longer. Is there a way that I can add one button / folder on the Quick Access that I can click on creating a drop-down and having the macros within it.?

    Thank you in advance.

  2. #2
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Adding a personal drop-down option on the Quick Access Toolbar

    I think it's only possible by using an add-in, as explained here: http://www.rondebruin.nl/win/s2/win004.htm

    However, you could do almost the same by customising your Ribbon instead, putting all your macros in a new tab; see here: https://support.office.com/en-gb/art...4-a31a460ecb31
    Regards,
    Aardigspook

    I recently started a new job so am a bit busy and may not reply quickly. Sorry - it's not personal - I will reply eventually.
    If your problem is solved, please go to 'Thread Tools' above your first post and 'Mark this Thread as Solved'.
    If you use commas as your decimal separator (1,23 instead of 1.23) then please replace commas with semi-colons in your formulae.
    You don't need to give me rep if I helped, but a thank-you is nice.

  3. #3
    Forum Contributor
    Join Date
    11-08-2012
    Location
    Manchester, UK
    MS-Off Ver
    Excel 2016
    Posts
    140

    Re: Adding a personal drop-down option on the Quick Access Toolbar

    OK, thank you.

  4. #4
    Forum Expert
    Join Date
    03-20-2015
    Location
    Primarily UK, sometimes NL
    MS-Off Ver
    Work: Office 365 / Home: Office 2010
    Posts
    2,405

    Re: Adding a personal drop-down option on the Quick Access Toolbar

    You're welcome, glad I could be of (limited) help and thanks for the rep.

+ 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. [SOLVED] Adding a 'Function' to the Quick Access Toolbar?
    By terrypin in forum Excel Programming / VBA / Macros
    Replies: 6
    Last Post: 01-07-2018, 02:48 PM
  2. [SOLVED] Quick Access Toolbar
    By plans in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 06-12-2017, 08:12 AM
  3. Adding buttons in quick access toolbar via macro
    By Crispy85 in forum Excel Programming / VBA / Macros
    Replies: 5
    Last Post: 03-01-2017, 10:06 AM
  4. Quick Access Toolbar
    By beingchinmay in forum Excel General
    Replies: 1
    Last Post: 08-12-2015, 07:50 AM
  5. Replies: 3
    Last Post: 01-12-2011, 01:47 PM
  6. Excel 2007 : Quick Access Toolbar
    By PosseJohn in forum Excel General
    Replies: 2
    Last Post: 10-27-2010, 02:19 AM
  7. Excel 2007 : adding custom button to quick access toolbar
    By surfengine in forum Excel General
    Replies: 6
    Last Post: 02-02-2010, 02:50 PM

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