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

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

Try Alt+F8 which will not show private macros.

Also for documentation you might take a look at

Build Table of Contents, similar listings, working with Hyperlinks
http://www.mvps.org/dmcritchie/excel/buildtoc.htm

for creating a list of Functions and Subroutines in all open workbooks:
Subroutine and Function Table for Open Workbooks (#ListFunctionsAndSubs)
http://www.mvps.org/dmcritchie/excel...nctionsAndSubs
and the coding can be found at
http://www.mvps.org/dmcritchie/excel/code/listfsubs.txt
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"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