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 | |