Hi all

I am writing some code that loops through multiple Excel workbooks (may
be open or not) and I am wondering if there's an Application or
VBProject property that I can access that indicates that a given
workbook has code in it.

It seems logical that there is such a property, as a workbook with code
prompts the user that macros are present. Is this property available
through VBA? And if so, how?

Thanks in advance

Paul Martin
Melbourne, Australia