Workbook.IsInplace Property

  • Article
Excel Developer Reference

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.

Visual Basic for Applications 
  Private Sub Workbook_Open()
    If ThisWorkbook.IsInPlace = True Then
        MsgBox "Editing in place"
    Else
        MsgBox "Editing in Microsoft Excel"
    End If
End Sub

See Also