Workbook.IsInplace Property

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:

• Workbook Object
• Workbook Object Members