Workbook.HasVBProject Property

Excel Developer Reference

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.

See Also