Workbook.ReadOnlyRecommended Property

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.

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

See Also

• Workbook Object
• Workbook Object Members