Microsoft KB Archive/159466

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

Article ID: 159466

Article Last Modified on 10/10/2006

-

APPLIES TO


 * Microsoft Excel 97 Standard Edition

-



This article was previously published under Q159466





SUMMARY
In Microsoft Excel 97, 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.



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

The following tables list all of the controls in the CommandBars collection, 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... 1

Chart 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... 919

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

Toolbars

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            1694

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

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

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

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         1138

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 For additional information, please see the following article in the Microsoft Knowledge Base:

162814 XL97: Sample Macros to Return ID for a CommandBar Control

