View Single Post
  #9   Report Post  
Posted to microsoft.public.excel.programming
Bob Phillips Bob Phillips is offline
external usenet poster
 
Posts: 10,593
Default duplicate vb projects occur when reopening a sheet

I had problems with MicroCharts COM addin generating phantom in my system.
Removing the addin cleared the problem.

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)



"Peter T" <peter_t@discussions wrote in message
...
Try searching this group for "Phantom Projects". Not so much in the hope
of
finding a solution but to give some comfort it doesn't only affect you!

Having said that, I think Jon Peltier had a theory that third party VSTO
type addns were implicated. That wasn't applicable to me and I posted some
code that sorted out mine, though I don't recall anyone reported it of
being
any use to them.

Regards,
Peter T

"Allan" wrote in message
...
Strange, I have written vb code which updates data when the file is

opened.
But when I close the workbook the vb project is still showing in the vb
window.
So when I reopen up the workbook I now have two instances of the vb

project
and none of the code executes. However when I close excel 2003 and open

the
workbook then everything runs fine.

Any ideas,

Allan
--
AH