+ Reply to Thread
Results 1 to 2 of 2

Excel 2007 Quick Access Tool Bar Problem with Macros

  1. #1
    Registered User
    Join Date
    10-01-2013
    Location
    Colombia
    MS-Off Ver
    Excel 2007
    Posts
    1

    Excel 2007 Quick Access Tool Bar Problem with Macros

    Hi there.
    I have 3 different files, each one of them has macros and I use buttons in the Quick Access Tool Bar to run the macros.
    When I have more than two of these files open and I run any of the macro that opens or closes one of the other files, the buttons in the QAT are duplicated. How can I avoid this behavior, is there any way to lock the QAT so it doesn’t get modified? It is important to mention that I have no problem with the macros... they run OK without any errors, but I don’t understand why the appearance of the QAT changes.
    One more thing. When I run the macro step by step with the Debugger nothing changes in the QAT and everything goes fine.
    I appreciate any information about this subject.

  2. #2
    Valued Forum Contributor Miroslav R.'s Avatar
    Join Date
    05-16-2013
    Location
    NMnV, Slovakia
    MS-Off Ver
    Excel 2007
    Posts
    479

    Re: Excel 2007 Quick Access Tool Bar Problem with Macros

    Hi,
    when You use exactly the same macro in different workbooks and You are the only one person handling this macro, why do You maintain this macro in all the workbooks?
    Possible solution will be to move the macro to personal.xlsb file, and link QAT to macro in this file...

    M

+ 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. Problem with Assigning a Macros to the Ribbon or Quick Access Bar in Excel 2010
    By Benefitus in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 06-07-2013, 08:12 AM
  2. Excel quick access tool bar
    By pmehrotr in forum Excel Formulas & Functions
    Replies: 3
    Last Post: 05-11-2013, 11:42 PM
  3. Excel 2007 : Icon in Quick Access tool bar
    By jazbath in forum Excel General
    Replies: 3
    Last Post: 09-30-2008, 03:58 AM
  4. Excel 2007 : Quick Access Tool Bar
    By Rick_Stanich in forum Excel General
    Replies: 2
    Last Post: 05-12-2008, 10:03 AM
  5. Excel 2007 - Quick Access Toolbar icons
    By Kayote in forum Excel General
    Replies: 0
    Last Post: 07-10-2007, 03:47 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