Ed

Not really, but opening any will result in the 'do you want to enable
macros' box, so it shouldn't take too long to find it

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ed" wrote in message
...
I sent a co-worker some macros, and he "put them in Excel". He used them
last week, but can't find them today. I'm thinking he put them in a
Worksheet or Workbook module of one particular file, rather than
Personal.xls or some other easily-located place.

Is there any way to search for all .xls files containing VBA code?

Ed