Deletes the CommandBar object from the collection.The use of CommandBars in some Microsoft Office applications has been superseded by the new Ribbon user interface. For more information, search help for the keyword "Ribbon."

Syntax

expression.Delete

expression Required. A variable that represents a object.

Remarks

For the Scripts collection, using the Delete method removes all scripts from the specified Microsoft Word document, Microsoft Excel worksheet, or Microsoft PowerPoint slide. A script anchor is represented by a shape in the host application. Therefore, the Shape object associated with each script anchor of type msoScriptAnchor is deleted from the Shapes collection in Excel and PowerPoint and from the InlineShapes and Shapes collections in Word.

Example

This example deletes all custom command bars that are not visible.

Visual Basic for Applications 
foundFlag = False delBars = 0 For Each bar In CommandBars If (bar.BuiltIn = False) And _ (bar.Visible = False) Then bar.Delete foundFlag = delBars = delBars + 1 End If Next bar If Not foundFlag Then MsgBox "No command bars have been deleted." Else MsgBox delBars & " custom bar(s) deleted." End If
ofv

See also: