What version?
Is this an XLSM XLSA?
Are ANY other projects open?
Have you checked the workbook names?
Have you named your projects?
It is actually possible to have two projects open with the same name.... If they are VBProject because you haven't given the project a unique name.
This may not be your problem so I think maybe more info is needed.
HTH
Lisa
Sent: Thu, Jan 31, 2013 8:47 pm
Subject: [ExcelVBA] VBA project does not unload
I have a weird problem. I have workbook with macros, user forms and and event
handler routines (like Worksheet_Change event and others). When I close this
workbook, the VBA project is still displayed in the project list and I even can
see the macro code (of the closed workbook). When I reopen the workbook, I get a
second occurrence of the VBA project with the same name.
Why does this occur and how can I unload the VBA project from the project list
when I close the workbook?
I appreciate your help,
sunnywulf
[Non-text portions of this message have been removed]
| Reply via web post | Reply to sender | Reply to group | Start a New Topic | Messages in this topic (2) |
Be sure to check out TechTrax Ezine for many, free Excel VBA articles! Go here: http://www.mousetrax.com/techtrax to enter the ezine, then search the ARCHIVES for EXCEL VBA.
----------------------------------
Visit our ExcelVBA group home page for more info and support files:
http://groups.yahoo.com/group/ExcelVBA
----------------------------------
More free tutorials and resources available at:
http://www.mousetrax.com
----------------------------------
Tidak ada komentar:
Posting Komentar