Expand Minimize

Workbook.ReadOnlyRecommended Property (Excel)

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

expression .ReadOnlyRecommended

expression A variable that represents a Workbook object.

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.

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
Show:
© 2015 Microsoft