You are currently offline, waiting for your internet to reconnect

XL97: List of ID Numbers for Built-In Command Bar Controls

This article was previously published under Q159466
Retired KB Content Disclaimer
This article was written about products for which Microsoft no longer offers support. Therefore, this article is offered "as is" and will no longer be updated.
SUMMARY
In Microsoft Excel 97, each element of the CommandBars collection uses aunique number for its ID property. This number determines the built-inaction for each control in the CommandBars collection.

NOTE: The value of the ID property for Custom controls is 1.
MORE INFORMATION
The CommandBars collection consists of CommandBar objects. The followingitems are represented by CommandBar objects:

  • Menu bars, toolbars, and shortcut menus
  • Menus on menu bars and toolbars
  • Submenus on menus, submenus, and shortcut menus
The following tables list all of the controls in the CommandBarscollection, arranged by the CommandBar to which the control belongs.
Worksheet Menu Bar------------------   CommandBar          Control               ID   -----------------------------------------------------------------------   File                &New...               18   File                &Open...              23   File                &Close                106   File                &Save                 3   File                Save &As...           748   File                Save &Workspace       846   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 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              M&ap...               1741   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   Tools               &Spelling...          2   Tools               &AutoCorrect...       793   Tools               S&hare Workbook...    2040   Tools               &Track Changes        30138   Tools               Merge &Workbooks      2044   Tools               &Protection           30029   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 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                &Contents and Index   983   Help                What's &This?         124   Help                Microsoft on the &Web 30222   Help                &Lotus 1-2-3 Help...  936   Help                &About Microsoft                          Excel              927   &Wizard             &Lookup...            1   &Wizard             &File Conversion...   1   &Wizard             &Conditional Sum...   1   &Wizard             &Web Form...          1Chart Menu Bar--------------   CommandBar          Control               ID   -----------------------------------------------------------------------   View                Sized with &Window    908   View                Ch&art Window         2571   Format              S&elected Chart                          Area...            917   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...          919Menu 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  A&ction               30083   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      A&ction               30083   Chart Menu Bar      &Window               30009   Chart Menu Bar      &Help                 30010Toolbars--------   CommandBar          Control               ID   -----------------------------------------------------------------------   Standard            &New                  2520   Standard            Open                  23   Standard            &Save                 3   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            &Web Toolbar          2934   Standard            &AutoSum              226   Standard            Paste Function        385   Standard            Sort &Ascending       210   Standard            Sort Des&cending      211   Standard            &Chart Wizard         436   Standard            M&ap...               1741   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          &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   PivotTable          &PivotTable           30253   PivotTable          &Wizard...            457   PivotTable          &Field...             460   PivotTable          Show &Pages...        461   PivotTable          &Ungroup...           3160   PivotTable          &Group...             3159   PivotTable          &Hide Detail          464   PivotTable          &Show Detail          462   PivotTable          &Refresh Data         459   PivotTable          &Label                995   PivotTable          &Data                 993   PivotTable          Label &and Data       994   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   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...   2188   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   Stop Recording      Stop &Recording      2186   Stop Recording      Relative Reference   896   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   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   Full Screen         F&ull Screen         178   Circular Reference  &Navigate Circular                          Reference:        1623   Circular Reference  Trace &Dependents    451   Circular Reference  &Trace Precedents    486   Circular Reference  Remove &All Arrows   453   Visual Basic        &Macros...           186   Visual Basic        &Record New Macro... 184   Visual Basic        Resume Macro         189   Visual Basic        &Visual Basic Editor 1695   Visual Basic        Control T&oolbox     548   Visual Basic        &Design Mode         1605   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   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   Exit Design Mode    &Design Mode         1605   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             &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   Query and Pivot     &Wizard...           457   Query and Pivot     &Refresh Data        459   Query and Pivot     &Select              30252   Query and Pivot     For&mulas            30254   Query and Pivot     &Field...            460   Query and Pivot     &Options...          1604   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   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   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   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            1694Shortcut Menus--------------   CommandBar          Control              ID   -----------------------------------------------------------------------   Workbook tabs       &Sheet List          957   Cell                Cu&t                 21   Cell                &Copy                19   Cell                &Paste               22   Cell                Paste &Special...    755   Cell                C&ells...            295   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           30094   Column              Cu&t                 21   Column              &Copy                19   Column              &Paste               22   Column              Paste &Special...    755   Column              &Insert              3183   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   Cell                Cu&t                 21   Cell                &Copy                19   Cell                &Paste               22   Cell                Paste &Special...    755   Cell                C&ells...            295   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                Insert Page &Break   1588   Cell                Reset All                          Page &Breaks      1585   Cell                &Set Print Area      364   Cell                &Add to Print Area   1583   Cell                &Exclude From                          Print Area        1586   Cell                R&eset Print Area    2038   Cell                Page Set&up...       247   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   Column              Insert Page &Break   1588   Column              Reset All                          Page &Breaks      1585   Column              &Set Print Area      364   Column              &Add to Print Area   1583   Column              &Exclude From                          Print Area        1586   Column              R&eset Print Area    2038   Column              Page Set&up...       247   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   Row                 Insert Page &Break   1588   Row                 Reset All                          Page &Breaks      1585   Row                 &Set Print Area      364   Row                 &Add to Print Area   1583   Row                 &Exclude From                          Print Area        1586   Row                 R&eset Print Area    2038   Row                 Page Set&up...       247   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               &Selected Object     917   Chart               Cle&ar               47   Formula Bar         Cu&t                 21   Formula Bar         &Copy                19   Formula Bar         &Paste               22   Formula Bar         &Format Cells...     855   Formula Bar         Pic&k From List...   1966   PivotTable Context      Menu             &Format Cells...     855   PivotTable Context      Menu             C&ells...            295   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             &Field...            460   PivotTable Context      Menu             &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              C&ells...            295   Layout              &Delete...           292   Layout              &Wizard...           457   Layout              &Refresh Data        459   Layout              &Select              30252   Layout              &Group and Outline   30251   Layout              For&mulas            30254   Layout              &Field...            460   Layout              &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   Shapes              Cu&t                 21   Shapes              &Copy                19   Shapes              &Paste               22   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           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           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           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           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           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           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           30094   System              &Restore             839   System              &Move                841   System              &Size                842   System              Mi&nimize            838   System              Ma&ximize            843   System              &Close               840Tear-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...  1053Draw 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       197AutoShapes 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   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   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   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   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   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         1138Tear-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				
For additional information, please see the following article in theMicrosoft Knowledge Base:
162814 XL97: Sample Macros to Return ID for a CommandBar Control
REFERENCES
For more information about the ID Property, click the Office Assistant inthe Visual Basic Editor, type "ID property" (without the quotation marks)click Search, and then click Id Property to view the topic.
XL97
Properties

Article ID: 159466 - Last Review: 10/10/2006 17:03:02 - Revision: 1.2

  • Microsoft Excel 97 Standard Edition
  • kbprogramming KB159466
Feedback