View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
mike molyneaux mike molyneaux is offline
external usenet poster
 
Posts: 6
Default find workbooks with macros

I need to write a macro that will open every workbook in a
folder & determine if the workbook contains macros.

Know how to find all workbooks in folders, but how can I
tell if they contain macros?

Is there a way to do this?

Thanks Mike