Workbook.IsInplace Property (Excel)
True if the specified workbook is being edited in place. False if the workbook has been opened in Microsoft Excel for editing. Read-only Boolean.
Syntax
expression .IsInplace
expression A variable that represents a Workbook object.
Example
This example indicates whether the workbook was opened for editing in place or in Microsoft Excel.
Private Sub Workbook_Open()
If ThisWorkbook.IsInPlace = True Then
MsgBox "Editing in place"
Else
MsgBox "Editing in Microsoft Excel"
End If
End Sub