+ Reply to Thread
Results 1 to 2 of 2

How can you programmatically add a macro button to QAT?

  1. #1
    Forum Contributor
    Join Date
    10-12-2018
    Location
    Leesburg, FL
    MS-Off Ver
    2013
    Posts
    113

    How can you programmatically add a macro button to QAT?

    I don't want to manually right click, customize QAT, and add a button. I want to write a macro that creates a QAT button using VBA.

  2. #2
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    East Sussex, UK
    MS-Off Ver
    365, varying versions/builds
    Posts
    21,289

    Re: How can you programmatically add a macro button to QAT?

    You can't do it directly. You have to amend the XML file that stores the QAT customisations and then restart Excel.
    Remember what the dormouse said
    Feed your head

+ 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. How to programmatically create a macro button usinf VBA
    By bvwalker1 in forum Excel Programming / VBA / Macros
    Replies: 4
    Last Post: 02-23-2019, 06:08 AM
  2. [SOLVED] Programmatically put an image on a button
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 08-15-2006, 01:55 PM
  3. [SOLVED] add button to UserForm programmatically
    By [email protected] in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 05-01-2006, 08:10 AM
  4. Assign a macro in a different workbook to a button programmatically
    By ctg in forum Excel Programming / VBA / Macros
    Replies: 0
    Last Post: 03-16-2005, 10:36 AM
  5. Programmatically change a button caption
    By quartz in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 02-18-2005, 01:03 PM
  6. [SOLVED] how do i programmatically insert a button on a worksheet
    By Qaspec in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 02-02-2005, 02:06 AM
  7. [SOLVED] Can I programmatically simulate clicking the 'stop macro' button in the VBE?
    By Alan in forum Excel Programming / VBA / Macros
    Replies: 9
    Last Post: 01-23-2005, 10:07 PM

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