I have never heard of that happening. What version of Excel? If 2007, is it
possible you saved the file(s) as non-macro enabled workbooks (*.xslx rather
than *.xlsm)? You might try downloading OpenOffice (www.openoffice.org) and
opening the workbook and see if the code is still intact to some extent.


--
Cordially,
Chip Pearson
Microsoft MVP - Excel
Pearson Software Consulting
www.cpearson.com
(email on the web site)

"John Quinn" wrote in message
...
For five weeks I have been writing Macros to do various functions

I have four WorkBooks. ACTStdnts, INTLStdnts, SATStdnts and TAKSStdnts.

All four of these Workbooks and all my Macros worked great in my Test
Directory

I Copied a live Workbook ACTStdnts into my Test Directory to Test it one
final time.
All my Macros (3000 Lines) were destroyed!!!!

Why did it destroy the Macros in my other three Workbooks.

This never happened with IBM Lotus, why is it happening with Microsoft.

Explanation Please

Thanks

J.Q.