Microsoft Office Tutorials and References
In Depth Information
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.
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.
Search JabSto ::




Custom Search