listing available(?) command bars
A list of avaiable (all?) command bars can be produced with the following loop. Some are reported multiple times.
option explicit
sub listcommandbars()
dim c as commandBar
for each c in commandbars
debug.print c.name
next c
end sub
| 3-D Settings | |
| Accessibility Checker | |
| ActiveX Control | |
| Add Command | |
| Align or Distribute | |
| Annotation Pens | |
| Annotation Pens | |
| Attachment Options | |
| AutoCalculate | |
| AutoFill | |
| AutoShapes | |
| Auto Sum | |
| Basic Shapes | |
| Block Arrows | |
| Borders | |
| Built-in Menus | |
| Button | |
| Callouts | |
| Canvas Popup | |
| Cell | |
| Chart | |
| Chart Menu Bar | |
| Chart Type | |
| Circular Reference | |
| Clip Art | |
| Clipboard | |
| Column | |
| Compare Side by Side | |
| Connector | |
| Connectors | |
| Control Toolbox | |
| Curve | |
| Curve Node | |
| Curve Segment | |
| Desktop | |
| Diagram | |
| Dialog | |
| Dictionaries | |
| Document | |
| Document Actions | |
| Document Management | |
| Document Updates | |
| Draw Border | |
| Drawing | |
| Drawing and Writing Pens | |
| Drawing Canvas | |
| Envelope | |
| Excel Control | |
| Excel Previewer | |
| Exit Design Mode | |
| External Data | |
| Fax Service | |
| Fill Color | |
| Filter Names | |
| Find Format | |
| Floor and Walls | |
| Flowchart | |
| Font Color | |
| Format Axis | |
| Format Data Series | |
| Format Legend Entry | |
| Format Object | |
| Formatting | |
| Forms | |
| Formula Auditing | |
| Formula Bar | |
| Full Screen | |
| History | |
| Inactive Chart | |
| Ink Annotations | |
| Ink Drawing And Writing | |
| Insert Shape | |
| Insights | |
| Layout | |
| Layout | |
| &Legacy Keyboard Support | |
| Line Color | |
| Lines | |
| List | |
| listCommandBars | |
| List Range Layout Popup | |
| List Range Popup | |
| Mail Merge Panes | |
| Meeting Workspace | |
| Nil | |
| Nondefault Drag And Drop | |
| Nudge | |
| Object/Plot | |
| Office Clipboard | |
| OLE Object | |
| Order | |
| Organization Chart | |
| Organization Chart Popup | |
| Paste Special Dropdown | |
| Pattern | |
| Phonetic Information | |
| Picture | |
| Pictures Context Menu | |
| PivotChart Menu | |
| Pivot Chart Popup | |
| PivotTable | |
| PivotTable Context Menu | |
| PivotTable Field List | |
| Plot Area | |
| Ply | Context menu on sheet tabs? |
| Proofing | |
| Property Editor | |
| Protection | |
| Query | |
| Query Layout | |
| Refresh | |
| Replace Format | |
| Research | |
| Reviewing | |
| Ribbon | |
| Ribbon Adapter | |
| Rotate Mode | |
| Rotate or Flip | |
| Row | |
| Script Anchor Popup | |
| Select | |
| Selection | |
| Series | |
| Shadow Settings | |
| Shapes | |
| Share | |
| Signatures | |
| Standard | |
| Stars & Banners | |
| Status Bar | |
| Stop Recording | |
| Task Pane | |
| Team | |
| Text To Speech | |
| Thesaurus | |
| Title Bar(Charting) | |
| Trendline | |
| Visual Basic | |
| Watch Window | |
| Web | |
| WordArt | |
| WordArt Context Menu | |
| Workbook tabs | |
| Worksheet Menu Bar | |
| XLM Cell | |
| XML Document | |
| XML Range Popup | |
| XML Source | |