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?:
Bookmarks