Can you post a screen shot of what the VBA project explorer panel looks like
after you've closed the .xls file?
Paul
-----------------------------------------
"Do all the good you can,
By all the means you can,
In all the ways you can,
In all the places you can,
At all the times you can,
To all the people you can,
As long as ever you can." - John Wesley
-----------------------------------------
________________________________
From: sunnywulf wolfram.schneider@maximintegrated.com>
To: ExcelVBA@yahoogroups.com
Sent: Mon, February 4, 2013 1:31:32 PM
Subject: [ExcelVBA] Re: VBA project does not unload
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]
>
[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 (4) |
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