File format is XLS (since tit neds to work also with XLS 2003), but I
tredi and saved as XLM (version 2010) and have the sam issue. There are
some other projects open siunce I loaad several Add-ins, but they never
interfered with any others macro projects. Workbook names are ok, and I
named the project also with a valid but also unique name. No projects
have the same name.
Regards,
Wolfram
--- In ExcelVBA@yahoogroups.com, 1z@... wrote:
>
> 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 (3) |
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