Edit

Share via


_Workbook.Comments Property

Definition

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

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>

Applies to