Duplication in VBA Project Explorer

[Don Wells]

2013-01-29_0942.png

I am running VBA under Excel 2003 SP3

Within the code, I open any one of a number of workbooks; manipulate the data within it; then save and close it. However on closing the file, its artifact remains in the VBA Project explorer. If the next instance of running the code (within the same Excel session) calls for the same workbook to be opened, a duplicate of the project is created in the Project explorer.

Has anyone else come across this behaviour? Any thoughts?

[HansV]

This behavior may be caused by an add-in. Try starting Excel without add-ins to see if the problem goes away. See Fixing Startup problems by Jan Karel Pieterse. Despite the title, it's not just for startup problems.

[Don Wells]

Thanks for the reminder Hans. I will try that.