Remove or displace VBA Projects

[Captain Randy]

When you click on Developer tab then click on Visual Basic tab(far left top corner).
I have all kinds of .XLAM and .XLSB, now each one is with one program or another. But how do I clean these up or have them not show up when I open a new workbook then I go into Visual Basic. The correct names for them is Project - VBAProject..

Any and all help would be appreciated. Thank You in advance.

 

[healey21]

If you have left the module sheets open whilst working in the VBA screen they will continue to open once the workbooks are open.

Perhaps close each module sheet before closing the workbooks.

The project window will display all Open Workbooks or possible Add Ins that are being used. So you might 5 (or more) workbooks displayed in the VBA screen even if you only have a single workbook open.

 

[Captain Randy]

Healey21

Thank You very much for your help. So I guess now I need to open each workbook and then close the VBA window that is with that workbook and then VBA will start closeing when I close the workbook that is with each one.
I think I'm correct in saying that... I hope...


Any way "Thank You" very much for your input...