WorkbookBase.ReadOnlyRecommended Property
Gets or sets a value that indicates whether the workbook was saved as read-only recommended.
Namespace: Microsoft.Office.Tools.Excel
Assembly: Microsoft.Office.Tools.Excel.v4.0.Utilities (in Microsoft.Office.Tools.Excel.v4.0.Utilities.dll)
Syntax
'Declaration
Public Property ReadOnlyRecommended As Boolean
Get
Set
public bool ReadOnlyRecommended { get; set; }
Property Value
Type: System.Boolean
true if the workbook was saved as read-only recommended; otherwise, false.
Remarks
When you open a workbook that was saved as read-only recommended, Microsoft Office Excel displays a message recommending that you open the workbook as read-only.
Use the SaveAs method to change this property.
Examples
The following code example displays a message box if the ReadOnlyRecommended property is true and the ReadOnly property is false, and then prompts the user to set the file access to read-only by calling the ChangeFileAccess method.
This example is for a document-level customization.
Private Sub MakeWorkbookReadOnly()
If Me.ReadOnlyRecommended AndAlso Not Me.ReadOnly Then
' Change the access level of the document to read-only
' if the user clicks yes.
If MessageBox.Show("Set this document to read-only?", _
"Sample", MessageBoxButtons.YesNo) = DialogResult.Yes Then
Me.ChangeFileAccess(Excel.XlFileAccess.xlReadOnly, Notify:=False)
End If
End If
End Sub
private void MakeWorkbookReadOnly()
{
if (this.ReadOnlyRecommended && !this.ReadOnly)
{
// Change the access level of the document to read-only if the user
// clicks yes.
if (MessageBox.Show("Set this document to read-only?",
"Sample", MessageBoxButtons.YesNo) == DialogResult.Yes)
{
this.ChangeFileAccess(Excel.XlFileAccess.xlReadOnly,
missing, false);
}
}
}
.NET Framework Security
- Full trust for the immediate caller. This member cannot be used by partially trusted code. For more information, see Using Libraries from Partially Trusted Code.