Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 193
Default VBAProject still visible after closing workbook

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.
  #2   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 193
Default VBAProject still visible after closing workbook

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!
  #3   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 11,123
Default VBAProject still visible after closing workbook

Thanks for the feedback Terry

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


"Terry" wrote in message ...
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!



  #4   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 2
Default VBAProject still visible after closing workbook

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


"Ron de Bruin" wrote:

Hi Terry

Maybe this is your problem
http://www.dicks-blog.com/archives/2...oogle-desktop/



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


"Terry" wrote in message ...
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
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Worksheet has to set to visible as it is not visible after saving and closing Excel by VB. Oscar Excel Programming 6 June 21st 05 10:39 PM
More than 1 workbook in a VBAProject R Avery Excel Programming 8 May 27th 04 06:40 PM
Closing workbook Ed Excel Programming 4 February 6th 04 03:41 PM
closing excel after closing a workbook CWalsh[_2_] Excel Programming 3 January 21st 04 03:33 PM
Closing a workbook Belinda Excel Programming 2 January 15th 04 01:27 PM


All times are GMT +1. The time now is 01:07 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"