Here we go.
I need the workbook Personal.xlsb there for my macros. It's hidden (most of the time), which is why, when I close the workbook I work with, there is a remaining blank Excel workbook that I have to manually close - Personal.xlsb. I've been doing this for weeks, but it's becoming annoying
Is there a way to automatically close remaining hidden workbooks? Could this be done through VBA (hopefully there's a simpler way though!)
Thanks
Look at this link.
http://answers.microsoft.com/en-us/o...3-35c91ccc97a1
Alan עַם יִשְׂרָאֵל חַי
Change an Ugly Report with Power Query
Database Normalization
Complete Guide to Power Query
Man's Mind Stretched to New Dimensions Never Returns to Its Original Form
Okay, thanks for that. Now, I'm not sure I understand what the second thing does (the add-in thing) but it seems to me it's not what I'm looking for.
The first solution looks interesting, but I don't know how to implement it.
What does "Public WithEvents App as Application" mean? Where do I select that? Should I create those from the Visual Basic tab? I've put the details below to make it easier.
Put code into ThisWorkboook module of the PERSONAL.XLSB and save
Public WithEvents App As Application
Please Login or Register to view this content.
Last edited by JonSnow; 01-29-2014 at 09:16 AM.
Your post does not comply with Rule 3 of our Forum RULES. Use code tags around code.
Posting code between [CODE]Please [url=https://www.excelforum.com/login.php]Login or Register [/url] to view this content.[/CODE] tags makes your code much easier to read and copy for testing, it also maintains VBA formatting.
Highlight your code and click the # icon at the top of your post window. More information about these and other tags can be found here
(This thread should receive no further responses until this moderation request is fulfilled, as per Forum Rule 7)
I really don't understand all the strictness around this minor issue. Regardless, thanks for pointing it out Alan, will know better in the future.
Now, can someone help with my questions above? Cheers
You may Shift+Click the X to close the application or you may also add the Exit button to the Quick Access Toolbar.
- Please remember to mark threads Solved with Thread Tools link at top of page.
- Please use code tags when posting code: [code]Place your code here[/code]
- Please read Forum Rules
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks