You are currently offline, waiting for your internet to reconnect

List of ID numbers for built-in CommandBar controls in Excel 2000

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
Properties

Article ID: 213552 - Last Review: 10/11/2006 00:48:25 - Revision: 3.4

  • Microsoft Excel 2000 Standard Edition
  • kbautomation kbinfo kbprogramming KB213552
Feedback