ReadOnlyRecommended Property

Microsoft Excel Visual Basic

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

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