Article ID: 159466
Article Last Modified on 10/10/2006
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
Additional query words: XL97
Keywords: kbprogramming KB159466