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