How to find lost macros?
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 |
How to find lost macros?
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 |
How to find lost macros?
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 |
All times are GMT +1. The time now is 12:26 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com