I've an XLS file (1.5 Mb) with several hundred lines of VBA code, that I've
stripped down to one line of code on a single button on a single sheet, that
line is

Crlf = CHR(10)

But it crashes with
  Compile Error ;
  Can't find project or library
Which is the error I'm getting when I try to use the 1.5MB file normally

If I create a new XLS file on the same PC with the same single line of code
on a single button it works (of course)

But I've scanned the XLS file with both McAffee + Nortons and shows no
infection

After all that, here's my question
Does anyone know of something simple I'm overlooking, some simple way of
switching off macros or corrupting them so the XLS files open and all
formula's work, all sheets are visible nothing seems wrong, except the
Macro's will not run ?

Thanks

Nick