Workbook still in VBA Project list after workbook is closed

jfranjione

New Member
Joined
Feb 2, 2009
Messages
17
Running Excel 2007 on Vista.

I have a macro-enabled Excel workbook. If I close the workbook, and subsequently open up VBA, .xlsm file is still listed in the VBA project list. However, when a colleague works with the same workbook, this does not happen.

I could provide lots more details, except I don't know which ones are relevant. So I'll wait for some feedback.
 

Excel Facts

Excel Can Read to You
Customize Quick Access Toolbar. From All Commands, add Speak Cells or Speak Cells on Enter to QAT. Select cells. Press Speak Cells.

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,099
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
In my experience this is usually down to the presence of a COM add-in whose LoadBehavior values in the registry is set to 3. Setting it to 2 cures the problem generally.
See for example this thread at DDOE.
 

jfranjione

New Member
Joined
Feb 2, 2009
Messages
17
In my experience this is usually down to the presence of a COM add-in whose LoadBehavior values in the registry is set to 3. Setting it to 2 cures the problem generally.
See for example this thread at DDOE.
Yow. This is sort of over my head. Some basic questions:

* How can I see a list of COM Add-ins for my machine?

* How can I see and change the LoadBehavior value?

* What does the value of "3" mean, vs. a value of "2"?

* What are the drawbacks of doing this? Will it cause some unexpected behavior in the COM Add-in?
 

RoryA

MrExcel MVP, Moderator
Joined
May 2, 2008
Messages
38,099
Office Version
  1. 365
  2. 2019
  3. 2016
  4. 2010
Platform
  1. Windows
  2. MacOS
Any user-specific ones will be listed in the COM Add-ins dialog (you can get to that by adding the COM Add-ins button to one of your toolbars) Unfortunately, ones installed for all users do not appear in the list so you have to check the registry for them.
They are listed at:
HKEY_CURRENT_USER\Software\Microsoft\Office\Excel\AddIns
and
HKEY_LOCAL_MACHINE\Software\Microsoft\Office\Excel\AddIns

in the registry.
The various values for LoadBehavior can be found here. You may want to try 9 instead of 2, or you may want to set all to 0 and then re-enable them one by one until you find out which is causing the issue.
 
Master Excel Bundle

Excel contains over 450 functions, with more added every year. That’s a huge number, so where should you start? Right here with this bundle.

Forum statistics

Threads
1,152,262
Messages
5,769,099
Members
425,517
Latest member
cheechburger

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Top