Page 400 - Microsoft Office Excel 2003 Programming Inside Out

Part 5: Manipulating Excel Objects
Microsoft Office Excel 2003 Programming Inside Out

Table 17-5. Key Properties and Methods of the CommandBarControl
Object (continued)
Property/Method Description
Delete(temporary) Method: removes this command bar from the
CommandBarControls collection associated with a command bar.
Temporary, when True, means that the control will be automatically
deleted when Excel ends.
Enabled Property: when False, means that the control is disabled.
Execute Method: runs the procedure specified in the OnAction property.
Height Property: contains the height of the command bar control in pixels.
HelpContextId Property: contains the help context ID number associated with the
command bar control. Remember that the HelpFile property must
also be specified for the help subsystem to work properly.
HelpFile Property: contains the name of the help file associated with the
command bar control.
Id Property: determines the built-in action for a control. Remember
that Id is set to 1 for all custom controls.
Index Property (read-only): returns the relative position of the command
bar control in the CommandBarControls collection.
Left Property (read-only): returns the distance between the left side of
the docking area and the command bar control.
Move (Bar, Before) Method: moves the current command bar control to the specified
command bar before the specified control. If Bar is not specified,
the current bar is assumed. If Before is not specified, the copy will
be placed at the end of the command bar.
OnAction Property: contains the name of a subroutine that will be run when
the user invokes the command bar control. You may also specify
a COM add-in by creating a string using the following syntax:
”!<add-in-name>”, where add-in-name is the name of the COM
add-in that should be used.
Parameter Property: contains extra information that can be used by the code
associated with the control to modify the default behavior of the
control.
Chapter 17
Priority Property: specifies the relative priority of a command bar control
so that if there isn’t space available in the docking area to fit all
the controls, controls with a value of 1 can’t be dropped. Valid
values range from 0 to 7.

374