Re: [ExcelVBA] VBA project does not unload

 

When I look at the screenshot you uploaded, I see an open workbook called
"QOS Template - Rev 4_0.xls".

Are you saying that you have not opened this workbook?

Where is this workbook stored? If it's in a startup folder, it'll be loaded
automatically and will be a hidden workbook. You'd stop this automatic load
by moving the file somewhere else.

Regards, Dave S

----- Original Message -----
From: "sunnywulf" wolfram.schneider@maximintegrated.com>
To: ExcelVBA@yahoogroups.com>
Sent: Friday, February 01, 2013 6:47 AM
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
>
>
>
> ------------------------------------
>
> ----------------------------------
> 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
>
> ----------------------------------Yahoo! Groups Links
>
>
>
>
>
> -----
> No virus found in this message.
> Checked by AVG - www.avg.com
> Version: 10.0.1430 / Virus Database: 2639/5569 - Release Date: 01/30/13
>

__._,_.___

Reply via web post

Reply to sender

Reply to group

Start a New Topic

Messages in this topic (7)

Recent Activity:

• New Files 1

Visit Your Group

----------------------------------
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

----------------------------------

Switch to: Text-Only, Daily Digest • Unsubscribe • Terms of Use • Send us Feedback

.

__,_._,___