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