Class CustomProperty (Excel VBA)

The class CustomProperty represents identifier information, which can be used as metadata for XML. To use a CustomProperty class variable it first needs to be instantiated, for example

Dim cprp as CustomProperty
Set cprp = ActiveSheet.CustomProperties(Index:=1)

For Each

Here is an example of processing the CustomProperty items in a collection.

Dim cprpCustomPropertie As CustomProperty
For Each cprpCustomPropertie In ActiveSheet.CustomProperties
	
Next cprpCustomPropertie

Delete

Deletes the object.

You can delete custom document properties, but you cannot delete a built-in document property.

ActiveSheet.CustomProperties(1).Delete

Name

Returns or sets a String value representing the name of the object.

ActiveSheet.CustomProperties(1).Name =

Value

Synonym for the Borders.LineStyle property.

ActiveSheet.CustomProperties(1).Value =