+ Reply to Thread
Results 1 to 2 of 2

How can you programmatically add a macro button to QAT?

  1. 02-27-2019, 04:06 PM #1
    bvwalker1 is offline
    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.
    Reply With QuoteRegister To Reply
  2. 02-27-2019, 06:03 PM #2
    romperstomper is offline
    Forum Expert romperstomper's Avatar
    Join Date
    08-13-2008
    Location
    England
    MS-Off Ver
    365, varying versions/builds
    Posts
    22,013

    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.
    Everyone who confuses correlation and causation ends up dead.
    Reply With QuoteRegister To Reply
+ Reply to Thread
« Previous Thread | Next 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. add button to UserForm programmatically
    By aaronfude@gmail.com 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

Forum Rules


Search Engine Friendly URLs by vBSEO 3.6.0 RC 1