Workbook.Excel8CompatibilityMode (Excel)

Provides developers with a way to check if the workbook is in compatibility mode.

In compatibility mode, certain functionality is disabled or functions differently. For example, in Excel 2007 or later there are more rows and columns available as compared to the earlier versions of Excel. In addition, structured referencing is available in Excel 2007 or later.

Dim booExcel8CompatibilityMode As Boolean
booExcel8CompatibilityMode = ActiveWorkbook.Excel8CompatibilityMode