XL2000: List of ID Numbers for Built-In CommandBar Controls

ID: q213552


The information in this article applies to:


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:


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 additional information, please see the following article in the Microsoft Knowledge Base:
Q213211 XL2000: Sample Macros to Return ID for a CommandBar Control

Additional query words:


Keywords          : kbprg kbdta KbVBA 
Version           : WINDOWS:2000
Platform          : WINDOWS 
Issue type        : kbinfo 

Last Reviewed: July 6, 1999