_Workbook.Comments Property

Definition

Namespace:

Microsoft.Office.Interop.Excel

Assembly:

Microsoft.Office.Interop.Excel.dll

Returns a Comments collection that represents all the comments for the specified worksheet. Read-only.

public:
 property System::String ^ Comments { System::String ^ get(); void set(System::String ^ value); };

public string Comments { get; set; }

Public Property Comments As String

Property Value

String

Returns String.

Examples

This example deletes all comments added by Jean Selva on the active sheet.

<span class="label">For Each c in ActiveSheet.Comments     If c.</span>
<i>Author</i>
<span class="label">= "Jean Selva" Then c.Delete Next</span>

This example deletes all comments added by Jean Selva on the active sheet.

<span class="label">For Each c in ActiveSheet.Comments     If c.</span>
<i>Author</i>
<span class="label">= "Jean Selva" Then c.Delete Next</span>

This example deletes all comments added by Jean Selva on the active sheet.

<span class="label">For Each c in ActiveSheet.Comments     If c.</span>
<i>Author</i>
<span class="label">= "Jean Selva" Then c.Delete Next</span>