WorkbookBase.ReadOnlyRecommended Property
Definition
Important
Some information relates to prerelease product that may be substantially modified before it’s released. Microsoft makes no warranties, express or implied, with respect to the information provided here.
Gets or sets a value that indicates whether the workbook was saved as read-only recommended.
public:
property bool ReadOnlyRecommended { bool get(); void set(bool value); };public bool ReadOnlyRecommended { get; set; }member this.ReadOnlyRecommended : bool with get, setPublic Property ReadOnlyRecommended As BooleanProperty Value
true if the workbook was saved as read-only recommended; otherwise, false.
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 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,
false);
}
}
}
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
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.