Excel deleting VBA modules and ActiveX controls

I have now copied files to my pc from an external hd (which has been disconnected from my pc since before this started happening) and the same thing happens to them as well.

It is affecting every excel file that has macros (vba modules)

All files without macros open normally

Maybe try removing Personal.xls?

I have a laptop running the same office xp installation.

I will copy files from both my pc and external hd to it and see what happens.

Originally Posted by davesexcel

Does this happen on the computer that the workbook was originally built on??

Yes, I have not tried the files on another computer yet.

The screwy thing is I have opened a file today and it did not happen the first time I opened it but it did the second time