I've never seen this before

[DonyBoy]

I have an excel file that has some macros here and there. Pretty basic macros. Worksheet_change() event etc.

I'm encountering a problem when I try to save and open the file again. It totally ruins the file. It says error occured, but Excel made the following repairs. Then below it says damage to the file is so extensive that Excel could not repair..

Problem with the file appears to be if you use File/Save As to copy the file from one directory to another (ie to memory stick, or from email to hard drive). When you then try to reopen it, it is corrupted. If you just copy across using windows explorer the file remains intact.

Any ideas?

 

[HughLerwill]

You had better post some of your code...

 

[Gavona]

Personally i would assume that there is some corruption in the workbook. I would move all the worksheets to a new workbook. See if that displays the same issues.
Assuming that is ok I would go into the editor and copy the code module sheets across. (If doing that causes issues then copy and paste instead, or export / import.)

Regards




Gavin