Workbook.HasVBProject Property (Excel)
Returns a Boolean that represents whether a workbook has an attached Microsoft Visual Basic for Applications project. Read-only Boolean.
Version Information
Version Added: Excel 2007
Syntax
expression .HasVBProject
expression A variable that represents a Workbook object.
Remarks
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.