Comments Property

Applies To

AddIn Object, Workbook Object.

Description

Returns or sets the comments for the object, as a string. Read-only for AddIn, read-write for Workbook.

Remarks

In Microsoft Excel for Windows 95, this property has been replaced by a built-in OLE document property. For more information about OLE document properties, see BuiltinDocumentProperties.

You cannot use this property with an AddIn object that represents an XLL file or an add-in that was created with the Microsoft Excel 4.0 macro language.

See Also

Author Property, Keywords Property, Subject Property, Title Property.

Example

This example displays the name and comments of the Solver add-in. Note that you can use Chr(13) to create a line break in a message box.


Set a = AddIns("Solver Add-In")
MsgBox a.Name & " description:" & Chr(13) & a.Comments

This example sets the comments for the active workbook.


ActiveWorkbook.Comments = "This workbook has been reviewed."