Detecting the presence of VB/Macros in a workbook

[Jon Svede]

Is it possible to detect the presence of macros or vb code in a sheet or  
workbook?  I don't want to execute it (obviously) I just want to be to able say 
if they exist or not.

Thanks,

Jon