Table of contents
Collapse the table of content
Expand the table of content

CommandBar.Delete Method (Office)

office 365 dev account|Last Updated: 6/12/2017
1 Contributor

Deletes the CommandBar object from the collection.

Note The use of CommandBars in some Microsoft Office applications has been superseded by the new ribbon component of the Microsoft Office Fluent user interface. For more information, search Help for the keyword "ribbon."


expression. Delete

expression Required. A variable that represents a CommandBar object.


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.


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

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

See also


CommandBar Object

Other resources

CommandBar Object Members

© 2018 Microsoft