Share via

Workbook.ReadOnlyRecommended Property

  • Article
Excel Developer Reference

True if the workbook was saved as read-only recommended. Read-only Boolean.

Syntax

expression.ReadOnlyRecommended

expression   A variable that represents a Workbook object.

Remarks

When you open a workbook that was saved as read-only recommended, Microsoft Excel displays a message recommending that you open the workbook as read-only.

Use the SaveAs method to change this property.

Example

This example displays a message if the active workbook is saved as read-only recommended.

Visual Basic for Applications 
  If ActiveWorkbook.ReadOnlyRecommended = True Then 
    MsgBox "This workbook is saved as read-only recommended"
End If

See Also