Thanks Phishphreek for the reply. The Wolfman is aware of OfficeCat. It's a good utility but only scans for a few MS vulnerabilities and nothing else.

Blocking the execution of a Macro with GPO will work, but won't solve my original issue, how to identify Macro's on a network?

Does anyone else know a utility to locate Macro's on a network?