Hi,
I have a workbook that has quite a bit of code underneath. Anyway, ONLY when having multiple workbooks open, clicking the X in the upper right corner (Windows 7), doesn't do anything, it should close Excel (querying to save changes). It only happens when the one multiple workbooks are open and the X is clicked in the workbook with all the VBA code. The workbook is password protected as is the code. When all other documents are closed, the X works.
Any ideas?
TIA!
When you say password protected, did you do that or another? If another, if you know the password, then look at the ThisWorkbook object to see what the code does.
If you've narrowed it down to one workbook, is it possible that that workbook has code in it that prevents closing via the X? If that seems unlikely (like if there is no obvious reason why a developer would want to stop the workbook from being closed), maybe it's an accident of sorts. It could be a macro that is running, for example one that is set to activate when a value is entered into a cell. This type of event will take up system resources because it is always "looking" at the cell and waiting for a value to be entered.
Is there anything special about the workbook that is causing this?
IF("helping me", "thanks", "need more detail?")
I am assuming that because you said it is password protected, you don't know the password and therefore can't just look in the code to see what's happening?
No, I know the password. I locked it down. Note some other info, there are dynamic active x controls added (about 100). There's also and auto_open and auto_close script.Originally Posted by jayherring86
The auto_open enables events on dynamically created active x controls, loads variables from hidden cells, and does some other clean up and preparation. The auto_close loads in to the cells the values of the variables.
What happens when the corner X is clicked when only the macro heavy workbook is open.
_
...How to Cross-post politely...
..Wrap code by selecting the code and clicking the # or read this. Thank you.
It closes the file (or prompts with a save dialog box). Only happens when multiple files (workbooks) are open and the user tries to close the one with all the macros
Last edited by steven_b46; 01-13-2015 at 06:36 PM.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
Bookmarks