Workbook.ReadOnlyRecommended Property (Excel)
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