VBA Project does not close when workbook is closed 
Author Message
 VBA Project does not close when workbook is closed

I've got a macro designed to run when a user opens a
workbook using Workbook_Open().

When one workbook containing this marco is closed and
another is opened, the macro does not run. A gander at the
VBA editor shows that Excel thinks the previous "project"
is still open.

This is occuring in XP and only happens when the files are
opened using Windows Explorer.

Any idea what's going on or how to get excel to recognize
that the original workbook containing the macro is closed?


Wed, 28 Sep 2005 06:59:20 GMT  
 [ 1 post ] 

 Relevant Pages 

1. Excel VBA workbook app hangs on open/close

2. Project hangs when using the close mothod to close txt file on vines map drive

3. .ldb not closing when .mdb is closed

4. VBA project stays resident after worksheet is closed

5. Closing MS-Project in VBA

6. Form does not close from the UpperRight X Close button

7. After closing my application, Task is active an will not close

8. window.close closes webbrowser but not the form itself

9. To Close or Not to Close that ...

10. Form Close Button Does Not Close the Form

11. window.close closes Webbrowser but not the form itself

12. Do not close form on clicking close button in Visual Basic


Powered by phpBB® Forum Software