Article ID: 213552
Article Last Modified on 10/11/2006
APPLIES TO
- Microsoft Excel 2000 Standard Edition
This article was previously published under Q213552
For a Microsoft Excel 97 version of this article, see 159466.
SUMMARY
In Microsoft Excel, each element of the CommandBars collection uses a unique number for its ID property. This number determines the built-in action for each control in the CommandBars collection.
Note The value of the ID property for Custom controls is 1.
The CommandBars collection consists of CommandBar objects. The following items are represented by CommandBar objects:
- Menu bars, toolbars, and shortcut menus.
- Menus on menu bars and toolbars.
- Submenus on menus, submenus, and shortcut menus.
MORE INFORMATION
The following tables list all of the controls in the CommandBars collection, arranged by the CommandBar to which the control belongs.
Menu Bars
CommandBar Control ID -------------------------------------------------------------------- Worksheet Menu Bar &File 30002 Worksheet Menu Bar &Edit 30003 Worksheet Menu Bar &View 30004 Worksheet Menu Bar &Insert 30005 Worksheet Menu Bar F&ormat 30006 Worksheet Menu Bar &Tools 30007 Worksheet Menu Bar &Data 30011 Worksheet Menu Bar &Window 30009 Worksheet Menu Bar &Help 30010 Chart Menu Bar &File 30002 Chart Menu Bar &Edit 30003 Chart Menu Bar &View 30004 Chart Menu Bar &Insert 30005 Chart Menu Bar F&ormat 30006 Chart Menu Bar &Tools 30007 Chart Menu Bar &Chart 30022 Chart Menu Bar &Window 30009 Chart Menu Bar &Help 30010
Worksheet Menu Bar
CommandBar Control ID -------------------------------------------------------------------- File &New 18 File &Open 23 File &Close 106 File &Save 3 File Save &As 748 File Save As Web Pa&ge 3823 File Save &Workspace 846 File We&b Page Preview 3655 File Page Set&up 247 File Prin&t Area 30255 File Print Pre&view 109 File &Print 4 File Sen&d To 30095 File Propert&ies 750 File Recent File Name Goes Here 831 File E&xit 752 Edit &Undo 128 Edit Can't &Undo 128 Edit &Repeat 37 Edit Can't Repeat 37 Edit Cu&t 21 Edit &Copy 19 Edit &Paste 22 Edit Paste &Special 755 Edit Paste as &Hyperlink 2787 Edit F&ill 30020 Edit Cle&ar 30021 Edit &Delete 478 Edit De&lete Sheet 847 Edit &Move or Copy Sheet 848 Edit &Find 1849 Edit R&eplace 313 Edit &Go To 757 Edit Lin&ks 759 Edit &Object 961 Edit &Object 30019 View &Normal 723 View &Page Break Preview 724 View &Toolbars 30045 View &Formula Bar 849 View &Status Bar 850 View &Header and Footer 762 View &Comments 1594 View Custom &Views 950 View F&ull Screen 178 View &Zoom 925 Insert C&ells 295 Insert &Rows 296 Insert &Columns 297 Insert &Worksheet 852 Insert C&hart 1957 Insert Page &Break 509 Insert Reset All Page &Breaks 1585 Insert &Function 385 Insert &Name 30023 Insert Co&mment 1589 Insert &Picture 30180 Insert &Object 546 Insert Hyperl&ink 1576 Format C&ells 855 Format &Row 30024 Format &Column 30025 Format S&heet 30026 Format &AutoFormat 786 Format Con&ditional Formatting 3058 Format &Style 254 Format Phone&tic Guide 30136 Tools &Spelling 2 Tools &AutoCorrect 793 Tools S&hare Workbook 2040 Tools &Track Changes 30138 Tools Merge &Workbooks 2044 Tools &Protection 30029 Tools O&nline Collaboration 30468 Tools &Goal Seek 856 Tools Sc&enarios 857 Tools A&uditing 30028 Tools &Macro 30017 Tools Add-&Ins 943 Tools &Customize 797 Tools &Options 522 Data &Sort 928 Data &Filter 30031 Data F&orm 860 Data Su&btotals 861 Data Va&lidation 2034 Data &Table 862 Data T&ext to Columns 806 Data Co&nsolidate 863 Data &Group and Outline 30032 Data &PivotTable and PivotChart Report 2915 Data Get External &Data 30101 Data &Refresh Data 459 Window &New Window 303 Window &Arrange 298 Window &Hide 865 Window &Unhide 866 Window &Split 302 Window &Freeze Panes 443 Window &Window Name Goes Here 830 Help Microsoft Excel &Help 984 Help Office on the &Web 375 Help Show the &Office Assistant 1004 Help Hide the &Office Assistant 1004 Help What's &This? 124 Help &Lotus 1-2-3 Help 936 Help Detect and &Repair 3774 Help &About Microsoft Excel 927
Chart Menu Bar
Includes only those controls unique to the Chart menu bar.
CommandBar Control ID -------------------------------------------------------------------- View Sized with &Window 908 View Ch&art Window 2571 Chart Chart &Type 918 Chart &Source Data 954 Chart Chart &Options 956 Chart &Location 955 Chart &Add Data 1963 Chart Add T&rendline 914 Chart 3-D &View 919
Shortcut Menus
CommandBar Control ID -------------------------------------------------------------------- Workbook tabs &Sheet1-Sheet4 957 Workbook tabs &Sheet List 957 Cell Cu&t 21 Cell &Copy 19 Cell &Paste 22 Cell Paste &Special 755 Cell &Insert 3181 Cell &Delete 292 Cell Clear Co&ntents 3125 Cell Insert Co&mment 2031 Cell Delete Co&mment 1592 Cell Sh&ow Comment 1593 Cell &Format Cells 855 Cell Pic&k From List 1966 Cell &Hyperlink 1576 Cell &Hyperlink 30094 Column Cu&t 21 Column &Copy 19 Column &Paste 22 Column Paste &Special 755 Column &Columns 297 Column &Delete 294 Column Clear Co&ntents 3125 Column &Format Cells 855 Column &Column Width 542 Column &Hide 886 Column &Unhide 887 Row Cu&t 21 Row &Copy 19 Row &Paste 22 Row Paste &Special 755 Row &Rows 296 Row &Delete 293 Row Clear Co&ntents 3125 Row &Format Cells 855 Row &Row Height 541 Row &Hide 883 Row &Unhide 884 Ply &Ungroup Sheets 1968 Ply &Insert 945 Ply &Delete 847 Ply &Rename 889 Ply &Move or Copy 848 Ply &Select All Sheets 946 Ply &View Code 1561 XLM Cell Cu&t 21 XLM Cell &Copy 19 XLM Cell &Paste 22 XLM Cell Paste &Special 755 XLM Cell C&ells 295 XLM Cell &Delete 292 XLM Cell Clear Co&ntents 3125 XLM Cell Insert Co&mment 2031 XLM Cell Delete Co&mment 1592 XLM Cell Sh&ow Comment 1593 XLM Cell &Format Cells 522 XLM Cell &Run 186 Document &Save 3 Document Save &As 748 Document &Print 4 Document Page Set&up 247 Document &Spelling 2 Document &New Window 303 Document &Arrange 298 Document &Zoom 925 Document &View Code 1561 Desktop &New 18 Desktop &Open 23 Desktop Save &Workspace 846 Desktop &Calculate Now 960 Desktop &Options 522 Desktop &Toolbars 30045 Nondefault Drag and Drop &Move Here 2046 Nondefault Drag and Drop &Copy Here 2045 Nondefault Drag and Drop Copy Here as &Values Only 2048 Nondefault Drag and Drop Copy Here as &Formats Only 2047 Nondefault Drag and Drop &Link Here 2158 Nondefault Drag and Drop Create &Hyperlink Here 2159 Nondefault Drag and Drop &Shift Down and Copy 2049 Nondefault Drag and Drop Shif&t Right and Copy 2050 Nondefault Drag and Drop Shift &Down and Move 2051 Nondefault Drag and Drop Shift &Right and Move 2052 Nondefault Drag and Drop C&ancel 569 AutoFill &Copy Cells 2019 AutoFill Fill &Series 2020 AutoFill Fill &Formats 2021 AutoFill Fill &Values 2022 AutoFill Fill &Days 2023 AutoFill Fill &Weekdays 2024 AutoFill Fill &Months 2025 AutoFill Fill &Years 2026 AutoFill &Linear Trend 2027 AutoFill &Growth Trend 2028 AutoFill S&eries 2029 Button Cu&t 21 Button &Copy 19 Button &Paste 22 Button Clear 47 Button Edit Object 961 Button &Object 30019 Button &Format Object 962 Button Bring to Fron&t 166 Button Send to Bac&k 167 Button &Group 164 Button Assig&n Macro 859 Dialog &Paste 22 Dialog Ta&b Order 469 Dialog &Run Dialog 470 Series &Selected Object 917 Series Chart &Type 918 Series &Source Data 954 Series Add T&rendline 914 Series Cle&ar 47 Plot Area &Selected Object 917 Plot Area Chart &Type 918 Plot Area &Source Data 954 Plot Area Chart &Options 956 Plot Area &Location 955 Plot Area 3-D &View 919 Plot Area Ch&art Window 2571 Plot Area Cle&ar 47 Floor and Walls &Selected Object 917 Floor and Walls 3-D &View 919 Floor and Walls Cle&ar 47 Trendline &Selected Object 917 Trendline Cle&ar 47 Chart &Chart Objects 1622 Chart &Selected Object 917 Chart Chart &Type 918 Chart Legend 439 Chart &Data Table 987 Chart Series in &Rows 989 Chart Series in &Columns 988 Chart &Angle Text Downward 1014 Chart &Angle Text Upward 1013 Format Data Series &Selected Object 917 Format Data Series Chart &Type 918 Format Data Series &Source Data 954 Format Data Series Add T&rendline 914 Format Data Series &Hide Detail 464 Format Data Series Sho&w Detail 4002 Format Axis &Selected Object 917 Format Axis Cle&ar 47 Format Axis &Hide Detail 464 Format Axis Sho&w Detail 462 Format Legend Entry &Selected Object 917 Format Legend Entry &Hide Detail 464 Format Legend Entry Sho&w Detail 462 Format Legend Entry Cle&ar 47 Formula Bar Cu&t 21 Formula Bar &Copy 19 Formula Bar &Paste 22 Formula Bar &Format Cells 855 Formula Bar Recon&version 3720 Formula Bar &Hangul Hanja Conversion 3492 Formula Bar &Edit Phonetic Field 1611 Formula Bar Pic&k From List 1966 PivotTable Context Menu &Format Cells 855 PivotTable Context Menu Forma&t Report 107 PivotTable Context Menu Pivot&Chart 3789 PivotTable Context Menu &Delete 292 PivotTable Context Menu &Wizard 457 PivotTable Context Menu &Refresh Data 459 PivotTable Context Menu &Select 30252 PivotTable Context Menu &Group and Outline 30251 PivotTable Context Menu For&mulas 30254 PivotTable Context Menu Ord&er 30485 PivotTable Context Menu &Field Settings 460 PivotTable Context Menu Table &Options 1604 PivotTable Context Menu Show &Pages 461 Query Cu&t 21 Query &Copy 19 Query &Paste 22 Query Paste &Special 755 Query C&ells 295 Query &Delete 292 Query Clear Co&ntents 3125 Query Insert Co&mment 2031 Query Delete Co&mment 1592 Query Sh&ow Comment 1593 Query &Format Cells 855 Query &Edit Query 1950 Query D&ata Range Properties 1951 Query Para&meters 537 Query &Refresh Data 459 Query Layout Cu&t 21 Query Layout &Copy 19 Query Layout &Paste 22 Query Layout Paste &Special 755 Query Layout C&ells 295 Query Layout &Delete 292 Query Layout Clear Co&ntents 3125 Query Layout Insert Co&mment 2031 Query Layout Delete Co&mment 1592 Query Layout Sh&ow Comment 1593 Query Layout &Format Cells 855 Query Layout &Edit Query 1950 Query Layout D&ata Range Properties 1951 Query Layout Para&meters 537 Query Layout &Refresh Data 459 Query Layout Insert Page &Break 1588 Query Layout Reset All Page &Breaks 1585 Query Layout &Set Print Area 364 Query Layout &Add to Print Area 1583 Query Layout &Exclude From Print Area 1586 Query Layout R&eset Print Area 2038 Query Layout Page Set&up 247 AutoCalculate &None 2012 AutoCalculate &Average 2013 AutoCalculate &Count 2014 AutoCalculate C&ount Nums 2015 AutoCalculate &Max 2016 AutoCalculate M&in 2017 AutoCalculate &Sum 2018 Object/Plot &Format Object 917 Object/Plot Chart &Type 918 Object/Plot &Source Data 954 Object/Plot Chart &Options 956 Object/Plot &Location 955 Object/Plot 3-D &View 919 Object/Plot Ch&art Window 2571 Object/Plot Cu&t 21 Object/Plot &Copy 19 Object/Plot &Paste 22 Object/Plot Cle&ar 47 Object/Plot Bring to Fron&t 166 Object/Plot Send to Bac&k 167 Object/Plot Assig&n Macro 859 Title Bar(Charting) &Print 4 Title Bar(Charting) Page Set&up 247 Title Bar(Charting) &Spelling 2 Layout &Format Cells 855 Layout &Delete 292 Layout &Wizard 457 Layout &Refresh Data 459 Layout &Select 30252 Layout &Group and Outline 30251 Layout For&mulas 30254 Layout &Field Settings 460 Layout Table &Options 1604 Layout Show &Pages 461 Layout Insert Page &Break 1588 Layout Reset All Page &Breaks 1585 Layout &Set Print Area 364 Layout &Add to Print Area 1583 Layout &Exclude From Print Area 1586 Layout R&eset Print Area 2038 Layout Page Set&up 247 Pivot Chart Popup &Selected Object 917 Pivot Chart Popup &PivotChart Options 1604 Pivot Chart Popup &Wizard 457 Pivot Chart Popup &Refresh Data 459 Pivot Chart Popup &Hide PivotChart Field Buttons 3956 Pivot Chart Popup &Group and Outline 30251 Pivot Chart Popup For&mulas 30254 Pivot Chart Popup Remo&ve Field 47 Phonetic Information Cu&t 21 Phonetic Information &Copy 19 Phonetic Information &Paste 22 Phonetic Information Pick from Phonetic List 3514 Shapes Cu&t 21 Shapes &Copy 19 Shapes &Paste 22 Shapes Recon&vert 3720 Shapes Edit Te&xt 1401 Shapes &Grouping 30175 Shapes O&rder 30078 Shapes Assig&n Macro 859 Shapes Set AutoShape &Defaults 2179 Shapes &Object 962 Shapes &Hyperlink 1576 Shapes &Hyperlink 30094 Inactive Chart Cu&t 21 Inactive Chart &Copy 19 Inactive Chart &Paste 22 Inactive Chart &Object 961 Inactive Chart &Grouping 30175 Inactive Chart O&rder 30078 Inactive Chart Assig&n Macro 859 Inactive Chart Set AutoShape Defaults 2179 Inactive Chart &Object 962 ActiveX Control Cu&t 21 ActiveX Control &Copy 19 ActiveX Control &Paste 22 ActiveX Control &Properties 222 ActiveX Control &View Code 1561 ActiveX Control &Object 30019 ActiveX Control &Grouping 30175 ActiveX Control O&rder 30078 ActiveX Control &Object 962 OLE Object Cu&t 21 OLE Object &Copy 19 OLE Object &Paste 22 OLE Object &Object 30019 OLE Object Show Picture Toolba&r 1413 OLE Object &Grouping 30175 OLE Object O&rder 30078 OLE Object Assig&n Macro 859 OLE Object &Object 962 Excel Control Cu&t 21 Excel Control &Copy 19 Excel Control &Paste 22 Excel Control Edit Te&xt 1401 Excel Control &Grouping 30175 Excel Control O&rder 30078 Excel Control Assig&n Macro 859 Excel Control &Object 962 WordArt Context Menu Cu&t 21 WordArt Context Menu &Copy 19 WordArt Context Menu &Paste 22 WordArt Context Menu Edit Te&xt 2094 WordArt Context Menu Show WordArt Toolba&r 1410 WordArt Context Menu &Grouping 30175 WordArt Context Menu O&rder 30078 WordArt Context Menu Assig&n Macro 859 WordArt Context Menu Set AutoShape &Defaults 2179 WordArt Context Menu &Object 962 WordArt Context Menu &Hyperlink 1576 WordArt Context Menu &Hyperlink 30094 Curve Cu&t 21 Curve &Copy 19 Curve &Paste 22 Curve &Edit Points 206 Curve Open C&urve 2693 Curve Close C&urve 1420 Curve &Grouping 30175 Curve O&rder 30078 Curve Assig&n Macro 859 Curve Set AutoShape &Defaults 2179 Curve &Object 962 Curve &Hyperlink 1576 Curve &Hyperlink 30094 Curve Node &Add Point 1415 Curve Node De&lete Point 1416 Curve Node Open C&urve 2693 Curve Node Close C&urve 1420 Curve Node Au&to Point 1421 Curve Node &Smooth Point 1422 Curve Node St&raight Point 1423 Curve Node &Corner Point 1424 Curve Node Exit &Edit Point 1425 Curve Node Set AutoShape &Defaults 2179 Curve Node &Object 962 Curve Node &Hyperlink 1576 Curve Node &Hyperlink 30094 Curve Segment &Add Point 1415 Curve Segment De&lete Segment 2692 Curve Segment Open C&urve 2693 Curve Segment Close C&urve 1420 Curve Segment &Straight Segment 1417 Curve Segment &Curved Segment 1418 Curve Segment Exit &Edit Point 1425 Curve Segment Set AutoShape &Defaults 2179 Curve Segment &Object 962 Curve Segment &Hyperlink 1576 Curve Segment &Hyperlink 30094 Pictures Context Menu Cu&t 21 Pictures Context Menu &Copy 19 Pictures Context Menu &Paste 22 Pictures Context Menu Show Picture Toolba&r 1413 Pictures Context Menu &Grouping 30175 Pictures Context Menu O&rder 30078 Pictures Context Menu Assig&n Macro 859 Pictures Context Menu &Object 962 Pictures Context Menu &Hyperlink 1576 Pictures Context Menu &Hyperlink 30094 Rotate Mode Cu&t 21 Rotate Mode &Copy 19 Rotate Mode &Paste 22 Rotate Mode &Exit Rotate Mode 1412 Rotate Mode Set AutoShape &Defaults 2179 Rotate Mode &Object 962 Connector Cu&t 21 Connector &Copy 19 Connector &Paste 22 Connector &Straight Connector 2091 Connector &Elbow Connector 2092 Connector C&urved Connector 2093 Connector Rerou&te Connectors 1033 Connector Assig&n Macro 859 Connector Set AutoShape &Defaults 2179 Connector &Object 962 Connector &Hyperlink 1576 Connector &Hyperlink 30094 Script Anchor Popup Cu&t 21 Script Anchor Popup &Copy 19 Script Anchor Popup &Paste 22 Script Anchor Popup &Insert Script 3628 Add Command File 30054 Add Command Edit 30055 Add Command View 30056 Add Command Insert 30057 Add Command Format 30058 Add Command Tools 30059 Add Command Data 30241 Add Command Window and Help 30061 Add Command Drawing 30073 Add Command AutoShapes 30246 Add Command Charting 30243 Add Command Web 30249 Add Command Forms 30244 Add Command Control Toolbox 30247 Add Command Macros 30062 Built-in Menus &File 30002 Built-in Menus Prin&t Area 30255 Built-in Menus Sen&d To 30095 Built-in Menus &Edit 30003 Built-in Menus F&ill 30020 Built-in Menus Cle&ar 30021 Built-in Menus &Object 30019 Built-in Menus &View 30004 Built-in Menus &Toolbars 30045 Built-in Menus &Insert 30005 Built-in Menus &Name 30023 Built-in Menus &Picture 30180 Built-in Menus F&ormat 30006 Built-in Menus &Row 30024 Built-in Menus &Column 30025 Built-in Menus S&heet 30026 Built-in Menus Phone&tic Guide 30136 Built-in Menus &Tools 30007 Built-in Menus &Track Changes 30138 Built-in Menus &Protection 30029 Built-in Menus A&uditing 30028 Built-in Menus &Macro 30017 Built-in Menus &Data 30011 Built-in Menus &Filter 30031 Built-in Menus &Group and Outline 30032 Built-in Menus Get External &Data 30101 Built-in Menus &Window 30009 Built-in Menus &Help 30010 System &Restore 839 System &Move 841 System &Size 842 System Mi&nimize 838 System Ma&ximize 843 System &Close 840
Tear-off Menus on Drawing Toolbar
CommandBar Control ID -------------------------------------------------------------------- Font Color &Automatic Color 1926 Font Color &Color Scheme 1927 Font Color &Color 1928 Fill Color &No Color 1453 Fill Color &Color Scheme 1455 Fill Color &Standard Colors 1456 Fill Color &Recently Used Colors 1457 Fill Color &More Fill Colors 1051 Fill Color &Fill Effects 1006 Fill Color &Fill Effects 2668 Line Color &No Color 1458 Line Color &Automatic Color 1459 Line Color &Color Scheme 1460 Line Color &Standard Colors 1461 Line Color &Recently Used Colors 1462 Line Color &More Line Colors 1052 Line Color &Patterned Lines 1053
Tear-off Menus
CommandBar Control ID -------------------------------------------------------------------- Borders &Border 1618 Chart Type &Chart Type 1616 Pattern &Pattern 1617 Pattern &Automatic Color 3141 Pattern &Color Scheme 1929 Pattern &Color 1930
Toolbars
CommandBar Control ID -------------------------------------------------------------------- Standard &New 2520 Standard Open 23 Standard &Save 3 Standard &Mail Recipient 3738 Standard Print 2521 Standard Print Pre&view 109 Standard &Spelling 2 Standard Cu&t 21 Standard &Copy 19 Standard &Paste 22 Standard &Format Painter 108 Standard &Undo 128 Standard &Redo 129 Standard Hyperl&ink 1576 Standard &AutoSum 226 Standard Paste Function 385 Standard Sort &Ascending 210 Standard Sort Des&cending 211 Standard &Chart Wizard 436 Standard &Drawing 204 Standard &Zoom: 1733 Standard Microsoft Excel &Help 984 Formatting &Font: 1728 Formatting &Font Size: 1731 Formatting &Bold 113 Formatting &Italic 114 Formatting &Underline 115 Formatting &Align Left 120 Formatting &Center 122 Formatting &Align Right 121 Formatting &Merge and Center 402 Formatting &Text Direction 4027 Formatting Sheet Right to left 1925 Formatting &Currency Style 395 Formatting &Percent Style 396 Formatting &Comma Style 397 Formatting &Increase Decimal 398 Formatting &Decrease Decimal 399 Formatting &Decrease Indent 3162 Formatting &Increase Indent 3161 Formatting &Borders 203 Formatting &Fill Color 1691 Formatting &Font Color 401 3-D Settings &3-D On/Off 1374 3-D Settings &Tilt Down 1375 3-D Settings &Tilt Up 1376 3-D Settings &Tilt Left 1377 3-D Settings &Tilt Right 1378 3-D Settings &Depth 1379 3-D Settings &Direction 1380 3-D Settings &Lighting 1382 3-D Settings &Surface 1383 3-D Settings 3-D Color 1694 Auditing &Trace Precedents 486 Auditing &Remove Precedent Arrows 452 Auditing Trace &Dependents 451 Auditing &Remove Dependent Arrows 450 Auditing Remove &All Arrows 453 Auditing Trace &Error 463 Auditing Co&mment 1589 Auditing Circle Invalid Data 2035 Auditing &Clear Validation Circles 2055 Chart &Chart Objects: 1622 Chart &Selected Object 917 Chart Chart &Type 918 Chart &Legend 439 Chart &Data Table 987 Chart Series in &Rows 989 Chart Series in &Columns 988 Chart &Angle Text Downward 1014 Chart &Angle Text Upward 1013 Circular Reference &Navigate Circular Reference: 1623 Circular Reference Trace &Dependents 451 Circular Reference &Trace Precedents 486 Circular Reference Remove &All Arrows 453 Control Toolbox &Design Mode 1605 Control Toolbox &Properties 222 Control Toolbox &View Code 1561 Control Toolbox &Check Box 1848 Control Toolbox &Text Box 1850 Control Toolbox &Command Button 1851 Control Toolbox &Option Button 1852 Control Toolbox &List Box 1853 Control Toolbox &Combo Box 1854 Control Toolbox &Toggle Button 1855 Control Toolbox &Spin Button 1856 Control Toolbox &Scroll Bar 1857 Control Toolbox &Label 1858 Control Toolbox &Image 2089 Control Toolbox &More Controls 642 Drawing D&raw 30013 Drawing &Select Objects 182 Drawing Free Ro&tate 688 Drawing A&utoShapes 30177 Drawing &Line 130 Drawing &Arrow 243 Drawing &Rectangle 1111 Drawing &Oval 1119 Drawing Te&xt Box 139 Drawing &WordArt 1031 Drawing &Clip Art 682 Drawing &Fill Color 1691 Drawing &Line Color 1692 Drawing &Font Color 401 Drawing &Line Style 692 Drawing &Dash Style 693 Drawing &Arrow Style 694 Drawing &Shadow 394 Drawing &3-D 339 Exit Design Mode &Design Mode 1605 External Data &Edit Query 1950 External Data D&ata Range Properties 1951 External Data Para&meters 537 External Data &Refresh Data 459 External Data &Cancel Refresh 1953 External Data Refresh &All 1952 External Data &Refresh Status 1954 Forms &Label 476 Forms &Edit Box 219 Forms &Group Box 467 Forms &Button 282 Forms &Check Box 220 Forms &Option Button 446 Forms &List Box 448 Forms &Combo Box 221 Forms &Combination List-Edit 471 Forms &Combination Drop-Down Edit 475 Forms &Scroll Bar 447 Forms &Spinner 468 Forms Control Properties 222 Forms &Code 488 Forms Toggle Grid 485 Forms &Run Dialog 470 Full Screen F&ull Screen 178 Query and Pivot Forma&t Report 5473 Query and Pivot Pivot&Chart 3789 Query and Pivot &Wizard 457 Query and Pivot &Refresh Data 459 Query and Pivot C&lient-Server Settings 3988 Query and Pivot &Select 30252 Query and Pivot For&mulas 30254 Query and Pivot &Field Settings 460 Query and Pivot Table &Options 1604 Query and Pivot Show &Pages 461 Picture &From File 2619 Picture &Image Control 1403 Picture &More Contrast 1064 Picture &Less Contrast 1065 Picture &More Brightness 1066 Picture &Less Brightness 1067 Picture &Crop 732 Picture &Line Style 692 Picture &Object 962 Picture &Set Transparent Color 2827 Picture &Reset Picture 1362 PivotTable &PivotTable 30253 PivotTable &PivotChart 30469 PivotTable Format Report 5473 PivotTable &ChartWizard 436 PivotTable &Wizard 457 PivotTable &Hide Detail 464 PivotTable &Show Detail 462 PivotTable &Refresh Data 459 PivotTable Fi&eld Settings 460 PivotTable &Display Fields 3790 PivotTable &Data Area 4388 PivotTable &Non-Data Area 4391 PivotTable More Fields 3648 PivotTable &Data Area 4389 PivotTable &Non-Data Area 4392 PivotTable &Data Area 4390 PivotTable &Non-Data Area 4393 PivotTable More Fields 3650 Refresh Refre&sh 3817 Refresh Do &Not Refresh 3819 Reviewing Co&mment 1589 Reviewing &Previous Comment 1590 Reviewing &Next Comment 1591 Reviewing Sh&ow Comment 1593 Reviewing &Comments 1594 Reviewing Delete Co&mment 1592 Reviewing &Create Microsoft Outlook Task 837 Reviewing &Update File 455 Reviewing &Mail Recipient (As Attachment) 2188 Shadow Settings &Shadow On/Off 2175 Shadow Settings &Nudge Shadow Up 1068 Shadow Settings &Nudge Shadow Down 1069 Shadow Settings &Nudge Shadow Left 1070 Shadow Settings &Nudge Shadow Right 1071 Shadow Settings &Shadow Color 1693 Stop Recording Stop &Recording 2186 Stop Recording Relative Reference 896 Visual Basic &Macros 186 Visual Basic &Record New Macro 184 Visual Basic Security 3627 Visual Basic &Visual Basic Editor 1695 Visual Basic Control T&oolbox 548 Visual Basic &Design Mode 1605 Visual Basic Microsoft Script Editor 3631 Web &Back 1017 Web &Forward 1018 Web &Stop Current Jump 1019 Web &Refresh Current Page 1020 Web &Start Page 1016 Web Search the &Web 1922 Web Favorites 30176 Web &Go 30328 Web &Show Only Web Toolbar 1023 Web &Address: 1740 WordArt &WordArt 1031 WordArt Edit Te&xt 2094 WordArt &WordArt Gallery 1606 WordArt &Object 962 WordArt &WordArt Shape 1058 WordArt Free Ro&tate 688 WordArt &WordArt Same Letter Heights 1063 WordArt &WordArt Vertical Text 1061 WordArt &WordArt Alignment 1059 WordArt &WordArt Character Spacing 1060
PivotChart Menu on PivotTable Toolbar
CommandBar Control ID -------------------------------------------------------------------- PivotChart Menu &Field Settings 460 PivotChart Menu &Options 1604 PivotChart Menu &Refresh Data 459 PivotChart Menu &Hide PivotChart Field Buttons 3956 PivotChart Menu For&mulas 30254 PivotChart Menu Remo&ve Field 5416
AutoShapes Menu on Drawing Toolbar
CommandBar Control ID -------------------------------------------------------------------- AutoShapes &Lines 2631 AutoShapes Co&nnectors 2633 AutoShapes &Basic Shapes 2632 AutoShapes Block &Arrows 1049 AutoShapes &Flowchart 1048 AutoShapes &Stars and Banners 1050 AutoShapes &Callouts 1047 AutoShapes &More AutoShapes 3889 Lines &Line 130 Lines &Arrow 243 Lines &Double Arrow 1639 Lines &Curve 1041 Lines &Freeform 200 Lines &Scribble 409 Connectors St&raight Connector 1042 Connectors &Straight Arrow Connector 2640 Connectors &Straight Double-Arrow Connector 2641 Connectors &Elbow Connector 1043 Connectors &Elbow Arrow Connector 2642 Connectors &Elbow Double-Arrow Connector 2643 Connectors C&urved Connector 1044 Connectors &Curved Arrow Connector 2644 Connectors &Curved Double-Arrow Connector 2645 Flowchart &Flowchart: Process 1190 Flowchart &Flowchart: Alternate Process 1191 Flowchart &Flowchart: Decision 1192 Flowchart &Flowchart: Data 1193 Flowchart &Flowchart: Predefined Process 1194 Flowchart &Flowchart: Internal Storage 1195 Flowchart &Flowchart: Document 1196 Flowchart &Flowchart: Multidocument 1197 Flowchart &Flowchart: Terminator 1198 Flowchart &Flowchart: Preparation 1199 Flowchart &Flowchart: Manual Input 1200 Flowchart &Flowchart: Manual Operation 1201 Flowchart &Flowchart: Connector 1202 Flowchart &Flowchart: Off-page Connector 1203 Flowchart &Flowchart: Card 1204 Flowchart &Flowchart: Punched Tape 1205 Flowchart &Flowchart: Summing Junction 1206 Flowchart &Flowchart: Or 1207 Flowchart &Flowchart: Collate 1208 Flowchart &Flowchart: Sort 1209 Flowchart &Flowchart: Extract 1210 Flowchart &Flowchart: Merge 1211 Flowchart &Flowchart: Stored Data 1213 Flowchart &Flowchart: Delay 1218 Flowchart &Flowchart: Sequential Access Storage 1214 Flowchart &Flowchart: Magnetic Disk 1215 Flowchart &Flowchart: Direct Access Storage 1216 Flowchart &Flowchart: Display 1217 Basic Shapes &Rectangle 1111 Basic Shapes &Parallelogram 1112 Basic Shapes &Trapezoid 1113 Basic Shapes &Diamond 1114 Basic Shapes &Rounded Rectangle 1115 Basic Shapes &Octagon 1116 Basic Shapes &Isosceles Triangle 1117 Basic Shapes &Right Triangle 1118 Basic Shapes &Oval 1119 Basic Shapes &Hexagon 1120 Basic Shapes &Cross 1121 Basic Shapes &Regular Pentagon 1124 Basic Shapes &Can 1126 Basic Shapes &Cube 1122 Basic Shapes &Bevel 1130 Basic Shapes &Folded Corner 1129 Basic Shapes &Smiley Face 1131 Basic Shapes &Donut 1132 Basic Shapes &"No" Symbol 1133 Basic Shapes &Block Arc 1134 Basic Shapes &Heart 1141 Basic Shapes &Lightning Bolt 1140 Basic Shapes &Sun 2634 Basic Shapes &Moon 2635 Basic Shapes &Arc 1139 Basic Shapes &Double Bracket 2636 Basic Shapes &Double Brace 2637 Basic Shapes &Plaque 1123 Basic Shapes &Left Bracket 1135 Basic Shapes &Right Bracket 1136 Basic Shapes &Left Brace 1137 Basic Shapes &Right Brace 1138 Block Arrows &Right Arrow 1142 Block Arrows &Left Arrow 1143 Block Arrows &Up Arrow 1144 Block Arrows &Down Arrow 1145 Block Arrows &Left-Right Arrow 1146 Block Arrows &Up-Down Arrow 1147 Block Arrows &Quad Arrow 1148 Block Arrows &Left-Right-Up Arrow 1149 Block Arrows &Bent Arrow 1152 Block Arrows &U-Turn Arrow 1153 Block Arrows &Left-Up Arrow 1150 Block Arrows &Bent-Up Arrow 1151 Block Arrows &Curved Right Arrow 1160 Block Arrows &Curved Left Arrow 1161 Block Arrows &Curved Up Arrow 1162 Block Arrows &Curved Down Arrow 1163 Block Arrows &Striped Right Arrow 1154 Block Arrows &Notched Right Arrow 1155 Block Arrows &Pentagon 1156 Block Arrows &Chevron 1157 Block Arrows &Right Arrow Callout 1164 Block Arrows &Left Arrow Callout 1165 Block Arrows &Up Arrow Callout 1166 Block Arrows &Down Arrow Callout 1167 Block Arrows &Left-Right Arrow Callout 1168 Block Arrows &Up-Down Arrow Callout 1169 Block Arrows &Quad Arrow Callout 1170 Block Arrows &Circular Arrow 1158 Stars & Banners &Explosion 1 1188 Stars & Banners &Explosion 2 1189 Stars & Banners &4-Point Star 2638 Stars & Banners &5-Point Star 1183 Stars & Banners &8-Point Star 1184 Stars & Banners &16-Point Star 1185 Stars & Banners &24-Point Star 1186 Stars & Banners &32-Point Star 1187 Stars & Banners &Up Ribbon 1180 Stars & Banners &Down Ribbon 1179 Stars & Banners &Curved Up Ribbon 1182 Stars & Banners &Curved Down Ribbon 1181 Stars & Banners &Vertical Scroll 1127 Stars & Banners &Horizontal Scroll 1128 Stars & Banners &Wave 1125 Stars & Banners &Double Wave 2639 Callouts &Rectangular Callout 1172 Callouts &Rounded Rectangular Callout 1173 Callouts &Oval Callout 1174 Callouts &Cloud Callout 1175 Callouts &Line Callout 1 1219 Callouts &Line Callout 2 1176 Callouts &Line Callout 3 1177 Callouts &Line Callout 4 1178 Callouts &Line Callout 1 (Accent Bar) 1220 Callouts &Line Callout 2 (Accent Bar) 1221 Callouts &Line Callout 3 (Accent Bar) 1222 Callouts &Line Callout 4 (Accent Bar) 1223 Callouts &Line Callout 1 (No Border) 1224 Callouts &Line Callout 2 (No Border) 1225 Callouts &Line Callout 3 (No Border) 1226 Callouts &Line Callout 4 (No Border) 1227 Callouts &Line Callout 1 (Border and Accent Bar) 1228 Callouts &Line Callout 2 (Border and Accent Bar) 1229 Callouts &Line Callout 3 (Border and Accent Bar) 1230 Callouts &Line Callout 4(Border and Accent Bar) 1110
Draw Menu on Drawing Toolbar
CommandBar Control ID -------------------------------------------------------------------- Order Bring to Fron&t 166 Order Send to Bac&k 167 Order Bring &Forward 170 Order Send &Backward 171 Nudge &Up 1035 Nudge &Down 1036 Nudge &Left 1037 Nudge &Right 1038 Align or Distribute Align &Left 664 Align or Distribute Align &Center 668 Align or Distribute Align &Right 665 Align or Distribute Align &Top 666 Align or Distribute Align &Middle 669 Align or Distribute Align &Bottom 667 Align or Distribute Distribute &Horizontally 408 Align or Distribute Distribute &Vertically 465 Rotate or Flip Free Ro&tate 688 Rotate or Flip Rotate &Left 199 Rotate or Flip Rotate &Right 198 Rotate or Flip Flip &Horizontal 196 Rotate or Flip Flip &Vertical 197
For more information, click the following article number to view the article in the Microsoft Knowledge Base:
162814 Sample macros to return ID for a CommandBar control
Keywords: kbautomation kbinfo kbprogramming KB213552