Share via


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

See Also

Concepts

Workbook Object

Workbook Object Members