Excel.Workbook.IsInplace.md

title	keywords	f1_keywords	api_name	ms.assetid	ms.date	ms.localizationpriority
Workbook.IsInplace property (Excel)	vbaxl10.chm199184	vbaxl10.chm199184	Excel.Workbook.IsInplace	f492c09f-79d1-cde0-6cf1-db9644e41589	05/29/2019	medium

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

[!includeSupport and feedback]