Workbook.IsInplace (Excel)

True if the specified workbook is being edited in place. False if the workbook has been opened in Microsoft Excel for editing.

Dim booIsInplace As Boolean
booIsInplace = ActiveWorkbook.IsInplace