VBAProject still visible after closing workbook

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Terry - 12 Sep 2005 18:11 GMT

I guess I don't know if this is a problem or not, but while I was working in
the VBE I noticed that each time I closed and re-opened my workbook, the
VBAProject did not close. If I create a new shet and close it, the
VBAProject goes away. Is this normal behavior? Will this keep consuming
memory?

Thanks for the help.

Reply to this Message

Ron de Bruin - 12 Sep 2005 18:41 GMT

Hi Terry

Maybe this is your problem
http://www.dicks-blog.com/archives/2004/12/11/google-desktop/

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

>I guess I don't know if this is a problem or not, but while I was working in
> the VBE I noticed that each time I closed and re-opened my workbook, the
[quoted text clipped - 3 lines]
>
> Thanks for the help.

Reply to this Message

Terry - 12 Sep 2005 19:38 GMT

Thanks a bunch! The registry change
(HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Office.Desktop.Google.com\LoadBehaivor=2) worked for me.

Thanks again!

Reply to this Message

Ron de Bruin - 12 Sep 2005 19:43 GMT

Thanks for the feedback Terry

Signature

Regards Ron de Bruin
http://www.rondebruin.nl

> Thanks a bunch! The registry change
> (HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\Addins\Office.Desktop.Google.com\LoadBehaivor=2) worked for me.
>
> Thanks again!

Reply to this Message

Paulortrick - 29 May 2006 21:45 GMT

Hi Ron, Terry

Thanks for pointing this one out.
For reference, Google-Desktop is not the only culprit in this type of
problem. If anyone should happen across AutoDesk Vault 5, which includes an
Excel Plug-in, the registry Key "LoadBehavior" is found in the following
registry:
HKEY_CURRENT_USER\Software\Microsoft\Office\excel\Addins\ExcelVaultAddinApp2003.Addin

Does anyone know why loadbehavior is altered for excel?

Cheers,

Signature

Paulortrick

> Hi Terry
>
[quoted text clipped - 8 lines]
> >
> > Thanks for the help.

Reply to this Message