User Element

Contains a work area for entering formulas in user-specific elements that are referred to by other elements and add-on tools.

Syntax

<User
    [Name]
    [NameU]
    [Del]
    [ID]>
</User>

Attributes

Name

Optional string. The name of the element.

NameU

Optional string. The universal name of the element.

Del

Optional boolean. A flag indicating whether the element has been deleted locally. A value of 1 indicates that the element was deleted locally.

ID

Optional int. The unique ID of the element within its parent element.

Element properties

Element information

Parent elements

PageSheet

Shape

StyleSheet

DocumentSheet

Child elements

Value

Prompt

Remarks

Like the Scratch element, the User element can be used by your solution in many different ways. The advantage of the User element is that the elements it contains can be named— elements in the Scratch element cannot be named.

If your solution has a well-defined purpose, it is suggested that you use elements that can be named and therefore provide clarity, such as those contained in the User element. Elements contained in the Scratch element are typically used to isolate repeated complex calculations.

The Name, NameU, and ID attributes of the User element are optional; however, at least one of the three must be present in a User element.

The User element is relevant only when contained in a DocumentSheet, PageSheet, or Shape element. It is ignored when contained in a StyleSheet element.

Example

See also

User-Defined Cells section