Skip to content

Latest commit

 

History

History
45 lines (27 loc) · 1.07 KB

Excel.Workbook.ReadOnlyRecommended.md

File metadata and controls

45 lines (27 loc) · 1.07 KB
title keywords f1_keywords api_name ms.assetid ms.date ms.localizationpriority
Workbook.ReadOnlyRecommended property (Excel)
vbaxl10.chm199216
vbaxl10.chm199216
Excel.Workbook.ReadOnlyRecommended
3cae84e4-d5f0-f01c-64d9-ec586ffdf79c
05/29/2019
medium

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

[!includeSupport and feedback]