+ Reply to Thread
Results 1 to 1 of 1

Macro isn't closing the document correctly when called from the quick access toolbar

  1. #1
    Forum Contributor
    Join Date
    09-07-2010
    Location
    London
    MS-Off Ver
    Excel 2010
    Posts
    358

    Macro isn't closing the document correctly when called from the quick access toolbar

    I'm using the "Quick Access Toolbar" to add a button, the button is a macro in a macro holding document, I then can open other documents, press the button and it will do the macro even though they are .xlsx files.

    For some reason the ThisWorkbook.Close (False) isn't fully closing the document, it disappears of the screen but it doesn't get closed because if I run the macro again it says that the file is in use and only available in read-only / notify.

    I've tried to find a way round it by Nothing the workbook object for example: Set TargetWorkbook = Nothing but it's not working.

    After many many runs and edits to the code, I've found the offending line that is causing the bug in Office 2010 (unsure about other versions)... How do I fix it and get around it?:

    Please Login or Register  to view this content.
    Last edited by Hyflex; 01-26-2015 at 09:03 PM.

+ 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] Modify Excel 2010 Quick Access Toolbar Macro Icon using VBA
    By unhappyCamper in forum Excel Programming / VBA / Macros
    Replies: 3
    Last Post: 09-12-2014, 11:46 AM
  2. How to change help text associated with a macro button on Quick Access Toolbar?
    By XmisterIS in forum Excel Programming / VBA / Macros
    Replies: 2
    Last Post: 04-25-2014, 06:49 AM
  3. [SOLVED] Remove quick access toolbar
    By andrewgarcia86 in forum Excel Programming / VBA / Macros
    Replies: 1
    Last Post: 10-11-2013, 04:24 AM
  4. Excel 2007 : Quick Access Toolbar
    By PosseJohn in forum Excel General
    Replies: 2
    Last Post: 10-27-2010, 02:19 AM
  5. Excel 2007 : Add icons for Quick Access Toolbar
    By davegugg in forum Excel General
    Replies: 1
    Last Post: 06-02-2010, 05:59 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