I have a workbook that will open another workbook as soon as it is opened if a checkbox is checked. I also have before close procedures in both workbooks.
I have noticed that if I do not open a new workbook on open with the checkbox, wb2 will run its own before close procedures when the red x is hit. However, if I have a new workbook open immediately via the checkbox, when I hit the red x from wb2, wb1's before close procedures are run.
Why and how can I fix it?
I hope the way I wrote that doesn't make it sound like I think the problem is with the checkbox. I don't believe it has anything to do with that. I believe it has to do how the events are run.
I have noticed that if I do not open a new workbook on open with the checkbox, wb2 will run its own before close procedures when the red x is hit. However, if I have a new workbook open immediately via the checkbox, when I hit the red x from wb2, wb1's before close procedures are run.
Why and how can I fix it?
I hope the way I wrote that doesn't make it sound like I think the problem is with the checkbox. I don't believe it has anything to do with that. I believe it has to do how the events are run.
