Workbook.HasVBProject (Excel)

Returns a Boolean that represents whether a workbook has an attached Microsoft Visual Basic for Applications project.

This property is most useful in programmatically determining whether a workbook needs to be saved into a macro-enabled file format. If saved in another format, macros and code projects contained within the document may be lost.

Dim booHasVBProject As Boolean
booHasVBProject = ActiveWorkbook.HasVBProject