Paul,
See the recent thread in this NG "Need to scan xls files and identify if
they use macros...wanna use VB".

NickHK

"Paul Martin" wrote in message
oups.com...
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