Controls, Toolbars, OnKeys, : ID numbers

[muaythai]

Does anyone have any code that gives a full list of all ID numbers for the following:-

Controls
Toolbars / Commandbars
OnKeys

Or if not how to find them out (excluding trial & error!).

Thanks

 

[manuchauhan]

Just check it this helps.


Menu Bars
CommandBar Control ID
--------------------------------------------------------------------
Worksheet Menu Bar &File 30002
Worksheet Menu Bar &Edit 30003
Worksheet Menu Bar &View 30004
Worksheet Menu Bar &Insert 30005
Worksheet Menu Bar F&ormat 30006
Worksheet Menu Bar &Tools 30007
Worksheet Menu Bar &Data 30011
Worksheet Menu Bar &Window 30009
Worksheet Menu Bar &Help 30010

Chart Menu Bar &File 30002
Chart Menu Bar &Edit 30003
Chart Menu Bar &View 30004
Chart Menu Bar &Insert 30005
Chart Menu Bar F&ormat 30006
Chart Menu Bar &Tools 30007
Chart Menu Bar &Chart 30022
Chart Menu Bar &Window 30009
Chart Menu Bar &Help 30010

Worksheet Menu Bar
CommandBar Control ID
--------------------------------------------------------------------
File &New 18
File &Open 23
File &Close 106
File &Save 3
File Save &As 748
File Save As Web Pa&ge 3823
File Save &Workspace 846
File We&b Page Preview 3655
File Page Set&up 247
File Prin&t Area 30255
File Print Pre&view 109
File &Print 4
File Sen&d To 30095
File Propert&ies 750
File Recent File Name Goes Here 831
File E&xit 752

Edit &Undo 128
Edit Can't &Undo 128
Edit &Repeat 37
Edit Can't Repeat 37
Edit Cu&t 21
Edit &Copy 19
Edit &Paste 22
Edit Paste &Special 755
Edit Paste as &Hyperlink 2787
Edit F&ill 30020
Edit Cle&ar 30021
Edit &Delete 478
Edit De&lete Sheet 847
Edit &Move or Copy Sheet 848
Edit &Find 1849
Edit R&eplace 313
Edit &Go To 757
Edit Lin&ks 759
Edit &Object 961
Edit &Object 30019

View &Normal 723
View &Page Break Preview 724
View &Toolbars 30045
View &Formula Bar 849
View &Status Bar 850
View &Header and Footer 762
View &Comments 1594
View Custom &Views 950
View F&ull Screen 178
View &Zoom 925

Insert C&ells 295
Insert &Rows 296
Insert &Columns 297
Insert &Worksheet 852
Insert C&hart 1957
Insert Page &Break 509
Insert Reset All Page &Breaks 1585
Insert &Function 385
Insert &Name 30023
Insert Co&mment 1589
Insert &Picture 30180
Insert &Object 546
Insert Hyperl&ink 1576

Format C&ells 855
Format &Row 30024
Format &Column 30025
Format S&heet 30026
Format &AutoFormat 786
Format Con&ditional Formatting 3058
Format &Style 254
Format Phone&tic Guide 30136

Tools &Spelling 2
Tools &AutoCorrect 793
Tools S&hare Workbook 2040
Tools &Track Changes 30138
Tools Merge &Workbooks 2044
Tools &Protection 30029
Tools O&nline Collaboration 30468
Tools &Goal Seek 856
Tools Sc&enarios 857
Tools A&uditing 30028
Tools &Macro 30017
Tools Add-&Ins 943
Tools &Customize 797
Tools &Options 522

Data &Sort 928
Data &Filter 30031
Data F&orm 860
Data Su&btotals 861
Data Va&lidation 2034
Data &Table 862
Data T&ext to Columns 806
Data Co&nsolidate 863
Data &Group and Outline 30032
Data &PivotTable and PivotChart
Report 2915
Data Get External &Data 30101
Data &Refresh Data 459

Window &New Window 303
Window &Arrange 298
Window &Hide 865
Window &Unhide 866
Window &Split 302
Window &Freeze Panes 443
Window &Window Name Goes
Here 830

Help Microsoft Excel &Help 984
Help Office on the &Web 375
Help Show the &Office Assistant 1004
Help Hide the &Office Assistant 1004
Help What's &This? 124
Help &Lotus 1-2-3 Help 936
Help Detect and &Repair 3774
Help &About Microsoft Excel 927


Chart Menu Bar
Includes only those controls unique to the Chart menu bar. CommandBar Control ID
--------------------------------------------------------------------

View Sized with &Window 908
View Ch&art Window 2571

Chart Chart &Type 918
Chart &Source Data 954
Chart Chart &Options 956
Chart &Location 955
Chart &Add Data 1963
Chart Add T&rendline 914
Chart 3-D &View 919

Shortcut Menus
CommandBar Control ID
--------------------------------------------------------------------

Workbook tabs &Sheet1-Sheet4 957
Workbook tabs &Sheet List 957

Cell Cu&t 21
Cell &Copy 19
Cell &Paste 22
Cell Paste &Special 755
Cell &Insert 3181
Cell &Delete 292
Cell Clear Co&ntents 3125
Cell Insert Co&mment 2031
Cell Delete Co&mment 1592
Cell Sh&ow Comment 1593
Cell &Format Cells 855
Cell Pic&k From List 1966
Cell &Hyperlink 1576
Cell &Hyperlink 30094

Column Cu&t 21
Column &Copy 19
Column &Paste 22
Column Paste &Special 755
Column &Columns 297
Column &Delete 294
Column Clear Co&ntents 3125
Column &Format Cells 855
Column &Column Width 542
Column &Hide 886
Column &Unhide 887

Row Cu&t 21
Row &Copy 19
Row &Paste 22
Row Paste &Special 755
Row &Rows 296
Row &Delete 293
Row Clear Co&ntents 3125
Row &Format Cells 855
Row &Row Height 541
Row &Hide 883
Row &Unhide 884

Ply &Ungroup Sheets 1968
Ply &Insert 945
Ply &Delete 847
Ply &Rename 889
Ply &Move or Copy 848
Ply &Select All Sheets 946
Ply &View Code 1561

XLM Cell Cu&t 21
XLM Cell &Copy 19
XLM Cell &Paste 22
XLM Cell Paste &Special 755
XLM Cell C&ells 295
XLM Cell &Delete 292
XLM Cell Clear Co&ntents 3125
XLM Cell Insert Co&mment 2031
XLM Cell Delete Co&mment 1592
XLM Cell Sh&ow Comment 1593
XLM Cell &Format Cells 522
XLM Cell &Run 186

Document &Save 3
Document Save &As 748
Document &Print 4
Document Page Set&up 247
Document &Spelling 2
Document &New Window 303
Document &Arrange 298
Document &Zoom 925
Document &View Code 1561

Desktop &New 18
Desktop &Open 23
Desktop Save &Workspace 846
Desktop &Calculate Now 960
Desktop &Options 522
Desktop &Toolbars 30045

Nondefault Drag
and Drop &Move Here 2046
Nondefault Drag
and Drop &Copy Here 2045
Nondefault Drag
and Drop Copy Here as &Values Only 2048
Nondefault Drag
and Drop Copy Here as &Formats Only 2047
Nondefault Drag
and Drop &Link Here 2158
Nondefault Drag
and Drop Create &Hyperlink Here 2159
Nondefault Drag
and Drop &Shift Down and Copy 2049
Nondefault Drag
and Drop Shif&t Right and Copy 2050
Nondefault Drag
and Drop Shift &Down and Move 2051
Nondefault Drag
and Drop Shift &Right and Move 2052
Nondefault Drag
and Drop C&ancel 569

AutoFill &Copy Cells 2019
AutoFill Fill &Series 2020
AutoFill Fill &Formats 2021
AutoFill Fill &Values 2022
AutoFill Fill &Days 2023
AutoFill Fill &Weekdays 2024
AutoFill Fill &Months 2025
AutoFill Fill &Years 2026
AutoFill &Linear Trend 2027
AutoFill &Growth Trend 2028
AutoFill S&eries 2029

Button Cu&t 21
Button &Copy 19
Button &Paste 22
Button Clear 47
Button Edit Object 961
Button &Object 30019
Button &Format Object 962
Button Bring to Fron&t 166
Button Send to Bac&k 167
Button &Group 164
Button Assig&n Macro 859

Dialog &Paste 22
Dialog Ta&b Order 469
Dialog &Run Dialog 470

Series &Selected Object 917
Series Chart &Type 918
Series &Source Data 954
Series Add T&rendline 914
Series Cle&ar 47

Plot Area &Selected Object 917
Plot Area Chart &Type 918
Plot Area &Source Data 954
Plot Area Chart &Options 956
Plot Area &Location 955
Plot Area 3-D &View 919
Plot Area Ch&art Window 2571
Plot Area Cle&ar 47

Floor and Walls &Selected Object 917
Floor and Walls 3-D &View 919
Floor and Walls Cle&ar 47

Trendline &Selected Object 917
Trendline Cle&ar 47

Chart &Chart Objects 1622
Chart &Selected Object 917
Chart Chart &Type 918
Chart Legend 439
Chart &Data Table 987
Chart Series in &Rows 989
Chart Series in &Columns 988
Chart &Angle Text Downward 1014
Chart &Angle Text Upward 1013

Format Data Series &Selected Object 917
Format Data Series Chart &Type 918
Format Data Series &Source Data 954
Format Data Series Add T&rendline 914
Format Data Series &Hide Detail 464
Format Data Series Sho&w Detail 4002

Format Axis &Selected Object 917
Format Axis Cle&ar 47
Format Axis &Hide Detail 464
Format Axis Sho&w Detail 462

Format Legend Entry &Selected Object 917
Format Legend Entry &Hide Detail 464
Format Legend Entry Sho&w Detail 462
Format Legend Entry Cle&ar 47

Formula Bar Cu&t 21
Formula Bar &Copy 19
Formula Bar &Paste 22
Formula Bar &Format Cells 855
Formula Bar Recon&version 3720
Formula Bar &Hangul Hanja Conversion 3492
Formula Bar &Edit Phonetic Field 1611
Formula Bar Pic&k From List 1966

PivotTable Context
Menu &Format Cells 855
PivotTable Context
Menu Forma&t Report 107
PivotTable Context
Menu Pivot&Chart 3789
PivotTable Context
Menu &Delete 292
PivotTable Context
Menu &Wizard 457
PivotTable Context
Menu &Refresh Data 459
PivotTable Context
Menu &Select 30252
PivotTable Context
Menu &Group and Outline 30251
PivotTable Context
Menu For&mulas 30254
PivotTable Context
Menu Ord&er 30485
PivotTable Context
Menu &Field Settings 460
PivotTable Context
Menu Table &Options 1604
PivotTable Context
Menu Show &Pages 461

Query Cu&t 21
Query &Copy 19
Query &Paste 22
Query Paste &Special 755
Query C&ells 295
Query &Delete 292
Query Clear Co&ntents 3125
Query Insert Co&mment 2031
Query Delete Co&mment 1592
Query Sh&ow Comment 1593
Query &Format Cells 855
Query &Edit Query 1950
Query D&ata Range Properties 1951
Query Para&meters 537
Query &Refresh Data 459

Query Layout Cu&t 21
Query Layout &Copy 19
Query Layout &Paste 22
Query Layout Paste &Special 755
Query Layout C&ells 295
Query Layout &Delete 292
Query Layout Clear Co&ntents 3125
Query Layout Insert Co&mment 2031
Query Layout Delete Co&mment 1592
Query Layout Sh&ow Comment 1593
Query Layout &Format Cells 855
Query Layout &Edit Query 1950
Query Layout D&ata Range Properties 1951
Query Layout Para&meters 537
Query Layout &Refresh Data 459
Query Layout Insert Page &Break 1588
Query Layout Reset All Page &Breaks 1585
Query Layout &Set Print Area 364
Query Layout &Add to Print Area 1583
Query Layout &Exclude From Print Area 1586
Query Layout R&eset Print Area 2038
Query Layout Page Set&up 247

AutoCalculate &None 2012
AutoCalculate &Average 2013
AutoCalculate &Count 2014
AutoCalculate C&ount Nums 2015
AutoCalculate &Max 2016
AutoCalculate M&in 2017
AutoCalculate &Sum 2018

Object/Plot &Format Object 917
Object/Plot Chart &Type 918
Object/Plot &Source Data 954
Object/Plot Chart &Options 956
Object/Plot &Location 955
Object/Plot 3-D &View 919
Object/Plot Ch&art Window 2571
Object/Plot Cu&t 21
Object/Plot &Copy 19
Object/Plot &Paste 22
Object/Plot Cle&ar 47
Object/Plot Bring to Fron&t 166
Object/Plot Send to Bac&k 167
Object/Plot Assig&n Macro 859

Title Bar(Charting) &Print 4
Title Bar(Charting) Page Set&up 247
Title Bar(Charting) &Spelling 2

Layout &Format Cells 855
Layout &Delete 292
Layout &Wizard 457
Layout &Refresh Data 459
Layout &Select 30252
Layout &Group and Outline 30251
Layout For&mulas 30254
Layout &Field Settings 460
Layout Table &Options 1604
Layout Show &Pages 461
Layout Insert Page &Break 1588
Layout Reset All Page &Breaks 1585
Layout &Set Print Area 364
Layout &Add to Print Area 1583
Layout &Exclude From Print Area 1586
Layout R&eset Print Area 2038
Layout Page Set&up 247

Pivot Chart Popup &Selected Object 917
Pivot Chart Popup &PivotChart Options 1604
Pivot Chart Popup &Wizard 457
Pivot Chart Popup &Refresh Data 459
Pivot Chart Popup &Hide PivotChart Field
Buttons 3956
Pivot Chart Popup &Group and Outline 30251
Pivot Chart Popup For&mulas 30254
Pivot Chart Popup Remo&ve Field 47

Phonetic Information Cu&t 21
Phonetic Information &Copy 19
Phonetic Information &Paste 22
Phonetic Information Pick from Phonetic List 3514

Shapes Cu&t 21
Shapes &Copy 19
Shapes &Paste 22
Shapes Recon&vert 3720
Shapes Edit Te&xt 1401
Shapes &Grouping 30175
Shapes O&rder 30078
Shapes Assig&n Macro 859
Shapes Set AutoShape &Defaults 2179
Shapes &Object 962
Shapes &Hyperlink 1576
Shapes &Hyperlink 30094

Inactive Chart Cu&t 21
Inactive Chart &Copy 19
Inactive Chart &Paste 22
Inactive Chart &Object 961
Inactive Chart &Grouping 30175
Inactive Chart O&rder 30078
Inactive Chart Assig&n Macro 859
Inactive Chart Set AutoShape Defaults 2179
Inactive Chart &Object 962

ActiveX Control Cu&t 21
ActiveX Control &Copy 19
ActiveX Control &Paste 22
ActiveX Control &Properties 222
ActiveX Control &View Code 1561
ActiveX Control &Object 30019
ActiveX Control &Grouping 30175
ActiveX Control O&rder 30078
ActiveX Control &Object 962

OLE Object Cu&t 21
OLE Object &Copy 19
OLE Object &Paste 22
OLE Object &Object 30019
OLE Object Show Picture Toolba&r 1413
OLE Object &Grouping 30175
OLE Object O&rder 30078
OLE Object Assig&n Macro 859
OLE Object &Object 962

Excel Control Cu&t 21
Excel Control &Copy 19
Excel Control &Paste 22
Excel Control Edit Te&xt 1401
Excel Control &Grouping 30175
Excel Control O&rder 30078
Excel Control Assig&n Macro 859
Excel Control &Object 962

WordArt Context Menu Cu&t 21
WordArt Context Menu &Copy 19
WordArt Context Menu &Paste 22
WordArt Context Menu Edit Te&xt 2094
WordArt Context Menu Show WordArt Toolba&r 1410
WordArt Context Menu &Grouping 30175
WordArt Context Menu O&rder 30078
WordArt Context Menu Assig&n Macro 859
WordArt Context Menu Set AutoShape &Defaults 2179
WordArt Context Menu &Object 962
WordArt Context Menu &Hyperlink 1576
WordArt Context Menu &Hyperlink 30094

Curve Cu&t 21
Curve &Copy 19
Curve &Paste 22
Curve &Edit Points 206
Curve Open C&urve 2693
Curve Close C&urve 1420
Curve &Grouping 30175
Curve O&rder 30078
Curve Assig&n Macro 859
Curve Set AutoShape &Defaults 2179
Curve &Object 962
Curve &Hyperlink 1576
Curve &Hyperlink 30094

Curve Node &Add Point 1415
Curve Node De&lete Point 1416
Curve Node Open C&urve 2693
Curve Node Close C&urve 1420
Curve Node Au&to Point 1421
Curve Node &Smooth Point 1422
Curve Node St&raight Point 1423
Curve Node &Corner Point 1424
Curve Node Exit &Edit Point 1425
Curve Node Set AutoShape &Defaults 2179
Curve Node &Object 962
Curve Node &Hyperlink 1576
Curve Node &Hyperlink 30094

Curve Segment &Add Point 1415
Curve Segment De&lete Segment 2692
Curve Segment Open C&urve 2693
Curve Segment Close C&urve 1420
Curve Segment &Straight Segment 1417
Curve Segment &Curved Segment 1418
Curve Segment Exit &Edit Point 1425
Curve Segment Set AutoShape &Defaults 2179
Curve Segment &Object 962
Curve Segment &Hyperlink 1576
Curve Segment &Hyperlink 30094

Pictures Context Menu Cu&t 21
Pictures Context Menu &Copy 19
Pictures Context Menu &Paste 22
Pictures Context Menu Show Picture Toolba&r 1413
Pictures Context Menu &Grouping 30175
Pictures Context Menu O&rder 30078
Pictures Context Menu Assig&n Macro 859
Pictures Context Menu &Object 962
Pictures Context Menu &Hyperlink 1576
Pictures Context Menu &Hyperlink 30094

Rotate Mode Cu&t 21
Rotate Mode &Copy 19
Rotate Mode &Paste 22
Rotate Mode &Exit Rotate Mode 1412
Rotate Mode Set AutoShape &Defaults 2179
Rotate Mode &Object 962

Connector Cu&t 21
Connector &Copy 19
Connector &Paste 22
Connector &Straight Connector 2091
Connector &Elbow Connector 2092
Connector C&urved Connector 2093
Connector Rerou&te Connectors 1033
Connector Assig&n Macro 859
Connector Set AutoShape &Defaults 2179
Connector &Object 962
Connector &Hyperlink 1576
Connector &Hyperlink 30094

Script Anchor Popup Cu&t 21
Script Anchor Popup &Copy 19
Script Anchor Popup &Paste 22
Script Anchor Popup &Insert Script 3628

Add Command File 30054
Add Command Edit 30055
Add Command View 30056
Add Command Insert 30057
Add Command Format 30058
Add Command Tools 30059
Add Command Data 30241
Add Command Window and Help 30061
Add Command Drawing 30073
Add Command AutoShapes 30246
Add Command Charting 30243
Add Command Web 30249
Add Command Forms 30244
Add Command Control Toolbox 30247
Add Command Macros 30062

Built-in Menus &File 30002
Built-in Menus Prin&t Area 30255
Built-in Menus Sen&d To 30095
Built-in Menus &Edit 30003
Built-in Menus F&ill 30020
Built-in Menus Cle&ar 30021
Built-in Menus &Object 30019
Built-in Menus &View 30004
Built-in Menus &Toolbars 30045
Built-in Menus &Insert 30005
Built-in Menus &Name 30023
Built-in Menus &Picture 30180
Built-in Menus F&ormat 30006
Built-in Menus &Row 30024
Built-in Menus &Column 30025
Built-in Menus S&heet 30026
Built-in Menus Phone&tic Guide 30136
Built-in Menus &Tools 30007
Built-in Menus &Track Changes 30138
Built-in Menus &Protection 30029
Built-in Menus A&uditing 30028
Built-in Menus &Macro 30017
Built-in Menus &Data 30011
Built-in Menus &Filter 30031
Built-in Menus &Group and Outline 30032
Built-in Menus Get External &Data 30101
Built-in Menus &Window 30009
Built-in Menus &Help 30010

System &Restore 839
System &Move 841
System &Size 842
System Mi&nimize 838
System Ma&ximize 843
System &Close 840


Tear-off Menus on Drawing Toolbar
CommandBar Control ID
--------------------------------------------------------------------

Font Color &Automatic Color 1926
Font Color &Color Scheme 1927
Font Color &Color 1928

Fill Color &No Color 1453
Fill Color &Color Scheme 1455
Fill Color &Standard Colors 1456
Fill Color &Recently Used Colors 1457
Fill Color &More Fill Colors 1051
Fill Color &Fill Effects 1006
Fill Color &Fill Effects 2668

Line Color &No Color 1458
Line Color &Automatic Color 1459
Line Color &Color Scheme 1460
Line Color &Standard Colors 1461
Line Color &Recently Used Colors 1462
Line Color &More Line Colors 1052
Line Color &Patterned Lines 1053

Tear-off Menus
CommandBar Control ID
--------------------------------------------------------------------

Borders &Border 1618

Chart Type &Chart Type 1616

Pattern &Pattern 1617
Pattern &Automatic Color 3141
Pattern &Color Scheme 1929
Pattern &Color 1930

Toolbars
CommandBar Control ID
--------------------------------------------------------------------
Standard &New 2520
Standard Open 23
Standard &Save 3
Standard &Mail Recipient 3738
Standard Print 2521
Standard Print Pre&view 109
Standard &Spelling 2
Standard Cu&t 21
Standard &Copy 19
Standard &Paste 22
Standard &Format Painter 108
Standard &Undo 128
Standard &Redo 129
Standard Hyperl&ink 1576
Standard &AutoSum 226
Standard Paste Function 385
Standard Sort &Ascending 210
Standard Sort Des&cending 211
Standard &Chart Wizard 436
Standard &Drawing 204
Standard &Zoom: 1733
Standard Microsoft Excel &Help 984

Formatting &Font: 1728
Formatting &Font Size: 1731
Formatting &Bold 113
Formatting &Italic 114
Formatting &Underline 115
Formatting &Align Left 120
Formatting &Center 122
Formatting &Align Right 121
Formatting &Merge and Center 402
Formatting &Text Direction 4027
Formatting Sheet Right to left 1925
Formatting &Currency Style 395
Formatting &Percent Style 396
Formatting &Comma Style 397
Formatting &Increase Decimal 398
Formatting &Decrease Decimal 399
Formatting &Decrease Indent 3162
Formatting &Increase Indent 3161
Formatting &Borders 203
Formatting &Fill Color 1691
Formatting &Font Color 401

3-D Settings &3-D On/Off 1374
3-D Settings &Tilt Down 1375
3-D Settings &Tilt Up 1376
3-D Settings &Tilt Left 1377
3-D Settings &Tilt Right 1378
3-D Settings &Depth 1379
3-D Settings &Direction 1380
3-D Settings &Lighting 1382
3-D Settings &Surface 1383
3-D Settings 3-D Color 1694

Auditing &Trace Precedents 486
Auditing &Remove Precedent Arrows 452
Auditing Trace &Dependents 451
Auditing &Remove Dependent Arrows 450
Auditing Remove &All Arrows 453
Auditing Trace &Error 463
Auditing Co&mment 1589
Auditing Circle Invalid Data 2035
Auditing &Clear Validation Circles 2055

Chart &Chart Objects: 1622
Chart &Selected Object 917
Chart Chart &Type 918
Chart &Legend 439
Chart &Data Table 987
Chart Series in &Rows 989
Chart Series in &Columns 988
Chart &Angle Text Downward 1014
Chart &Angle Text Upward 1013

Circular Reference &Navigate Circular Reference: 1623
Circular Reference Trace &Dependents 451
Circular Reference &Trace Precedents 486
Circular Reference Remove &All Arrows 453

Control Toolbox &Design Mode 1605
Control Toolbox &Properties 222
Control Toolbox &View Code 1561
Control Toolbox &Check Box 1848
Control Toolbox &Text Box 1850
Control Toolbox &Command Button 1851
Control Toolbox &Option Button 1852
Control Toolbox &List Box 1853
Control Toolbox &Combo Box 1854
Control Toolbox &Toggle Button 1855
Control Toolbox &Spin Button 1856
Control Toolbox &Scroll Bar 1857
Control Toolbox &Label 1858
Control Toolbox &Image 2089
Control Toolbox &More Controls 642

Drawing D&raw 30013
Drawing &Select Objects 182
Drawing Free Ro&tate 688
Drawing A&utoShapes 30177
Drawing &Line 130
Drawing &Arrow 243
Drawing &Rectangle 1111
Drawing &Oval 1119
Drawing Te&xt Box 139
Drawing &WordArt 1031
Drawing &Clip Art 682
Drawing &Fill Color 1691
Drawing &Line Color 1692
Drawing &Font Color 401
Drawing &Line Style 692
Drawing &Dash Style 693
Drawing &Arrow Style 694
Drawing &Shadow 394
Drawing &3-D 339

Exit Design Mode &Design Mode 1605

External Data &Edit Query 1950
External Data D&ata Range Properties 1951
External Data Para&meters 537
External Data &Refresh Data 459
External Data &Cancel Refresh 1953
External Data Refresh &All 1952
External Data &Refresh Status 1954

Forms &Label 476
Forms &Edit Box 219
Forms &Group Box 467
Forms &Button 282
Forms &Check Box 220
Forms &Option Button 446
Forms &List Box 448
Forms &Combo Box 221
Forms &Combination List-Edit 471
Forms &Combination Drop-Down Edit 475
Forms &Scroll Bar 447
Forms &Spinner 468
Forms Control Properties 222
Forms &Code 488
Forms Toggle Grid 485
Forms &Run Dialog 470

Full Screen F&ull Screen 178

Query and Pivot Forma&t Report 5473
Query and Pivot Pivot&Chart 3789
Query and Pivot &Wizard 457
Query and Pivot &Refresh Data 459
Query and Pivot C&lient-Server Settings 3988
Query and Pivot &Select 30252
Query and Pivot For&mulas 30254
Query and Pivot &Field Settings 460
Query and Pivot Table &Options 1604
Query and Pivot Show &Pages 461

Picture &From File 2619
Picture &Image Control 1403
Picture &More Contrast 1064
Picture &Less Contrast 1065
Picture &More Brightness 1066
Picture &Less Brightness 1067
Picture &Crop 732
Picture &Line Style 692
Picture &Object 962
Picture &Set Transparent Color 2827
Picture &Reset Picture 1362

PivotTable &PivotTable 30253
PivotTable &PivotChart 30469
PivotTable Format Report 5473
PivotTable &ChartWizard 436
PivotTable &Wizard 457
PivotTable &Hide Detail 464
PivotTable &Show Detail 462
PivotTable &Refresh Data 459
PivotTable Fi&eld Settings 460
PivotTable &Display Fields 3790
PivotTable &Data Area 4388
PivotTable &Non-Data Area 4391
PivotTable More Fields 3648
PivotTable &Data Area 4389
PivotTable &Non-Data Area 4392
PivotTable &Data Area 4390
PivotTable &Non-Data Area 4393
PivotTable More Fields 3650

Refresh Refre&sh 3817
Refresh Do &Not Refresh 3819

Reviewing Co&mment 1589
Reviewing &Previous Comment 1590
Reviewing &Next Comment 1591
Reviewing Sh&ow Comment 1593
Reviewing &Comments 1594
Reviewing Delete Co&mment 1592
Reviewing &Create Microsoft Outlook
Task 837
Reviewing &Update File 455
Reviewing &Mail Recipient (As
Attachment) 2188

Shadow Settings &Shadow On/Off 2175
Shadow Settings &Nudge Shadow Up 1068
Shadow Settings &Nudge Shadow Down 1069
Shadow Settings &Nudge Shadow Left 1070
Shadow Settings &Nudge Shadow Right 1071
Shadow Settings &Shadow Color 1693

Stop Recording Stop &Recording 2186
Stop Recording Relative Reference 896

Visual Basic &Macros 186
Visual Basic &Record New Macro 184
Visual Basic Security 3627
Visual Basic &Visual Basic Editor 1695
Visual Basic Control T&oolbox 548
Visual Basic &Design Mode 1605
Visual Basic Microsoft Script Editor 3631

Web &Back 1017
Web &Forward 1018
Web &Stop Current Jump 1019
Web &Refresh Current Page 1020
Web &Start Page 1016
Web Search the &Web 1922
Web Favorites 30176
Web &Go 30328
Web &Show Only Web Toolbar 1023
Web &Address: 1740

WordArt &WordArt 1031
WordArt Edit Te&xt 2094
WordArt &WordArt Gallery 1606
WordArt &Object 962
WordArt &WordArt Shape 1058
WordArt Free Ro&tate 688
WordArt &WordArt Same Letter Heights 1063
WordArt &WordArt Vertical Text 1061
WordArt &WordArt Alignment 1059
WordArt &WordArt Character Spacing 1060

PivotChart Menu on PivotTable Toolbar
CommandBar Control ID
--------------------------------------------------------------------

PivotChart Menu &Field Settings 460
PivotChart Menu &Options 1604
PivotChart Menu &Refresh Data 459
PivotChart Menu &Hide PivotChart Field
Buttons 3956
PivotChart Menu For&mulas 30254
PivotChart Menu Remo&ve Field 5416

AutoShapes Menu on Drawing Toolbar
CommandBar Control ID
--------------------------------------------------------------------

AutoShapes &Lines 2631
AutoShapes Co&nnectors 2633
AutoShapes &Basic Shapes 2632
AutoShapes Block &Arrows 1049
AutoShapes &Flowchart 1048
AutoShapes &Stars and Banners 1050
AutoShapes &Callouts 1047
AutoShapes &More AutoShapes 3889

Lines &Line 130
Lines &Arrow 243
Lines &Double Arrow 1639
Lines &Curve 1041
Lines &Freeform 200
Lines &Scribble 409

Connectors St&raight Connector 1042
Connectors &Straight Arrow Connector 2640
Connectors &Straight Double-Arrow
Connector 2641
Connectors &Elbow Connector 1043
Connectors &Elbow Arrow Connector 2642
Connectors &Elbow Double-Arrow Connector 2643
Connectors C&urved Connector 1044
Connectors &Curved Arrow Connector 2644
Connectors &Curved Double-Arrow
Connector 2645

Flowchart &Flowchart: Process 1190
Flowchart &Flowchart: Alternate Process 1191
Flowchart &Flowchart: Decision 1192
Flowchart &Flowchart: Data 1193
Flowchart &Flowchart: Predefined
Process 1194
Flowchart &Flowchart: Internal Storage 1195
Flowchart &Flowchart: Document 1196
Flowchart &Flowchart: Multidocument 1197
Flowchart &Flowchart: Terminator 1198
Flowchart &Flowchart: Preparation 1199
Flowchart &Flowchart: Manual Input 1200
Flowchart &Flowchart: Manual Operation 1201
Flowchart &Flowchart: Connector 1202
Flowchart &Flowchart: Off-page
Connector 1203
Flowchart &Flowchart: Card 1204
Flowchart &Flowchart: Punched Tape 1205
Flowchart &Flowchart: Summing Junction 1206
Flowchart &Flowchart: Or 1207
Flowchart &Flowchart: Collate 1208
Flowchart &Flowchart: Sort 1209
Flowchart &Flowchart: Extract 1210
Flowchart &Flowchart: Merge 1211
Flowchart &Flowchart: Stored Data 1213
Flowchart &Flowchart: Delay 1218
Flowchart &Flowchart: Sequential
Access Storage 1214
Flowchart &Flowchart: Magnetic Disk 1215
Flowchart &Flowchart: Direct
Access Storage 1216
Flowchart &Flowchart: Display 1217

Basic Shapes &Rectangle 1111
Basic Shapes &Parallelogram 1112
Basic Shapes &Trapezoid 1113
Basic Shapes &Diamond 1114
Basic Shapes &Rounded Rectangle 1115
Basic Shapes &Octagon 1116
Basic Shapes &Isosceles Triangle 1117
Basic Shapes &Right Triangle 1118
Basic Shapes &Oval 1119
Basic Shapes &Hexagon 1120
Basic Shapes &Cross 1121
Basic Shapes &Regular Pentagon 1124
Basic Shapes &Can 1126
Basic Shapes &Cube 1122
Basic Shapes &Bevel 1130
Basic Shapes &Folded Corner 1129
Basic Shapes &Smiley Face 1131
Basic Shapes &Donut 1132
Basic Shapes &"No" Symbol 1133
Basic Shapes &Block Arc 1134
Basic Shapes &Heart 1141
Basic Shapes &Lightning Bolt 1140
Basic Shapes &Sun 2634
Basic Shapes &Moon 2635
Basic Shapes &Arc 1139
Basic Shapes &Double Bracket 2636
Basic Shapes &Double Brace 2637
Basic Shapes &Plaque 1123
Basic Shapes &Left Bracket 1135
Basic Shapes &Right Bracket 1136
Basic Shapes &Left Brace 1137
Basic Shapes &Right Brace 1138

Block Arrows &Right Arrow 1142
Block Arrows &Left Arrow 1143
Block Arrows &Up Arrow 1144
Block Arrows &Down Arrow 1145
Block Arrows &Left-Right Arrow 1146
Block Arrows &Up-Down Arrow 1147
Block Arrows &Quad Arrow 1148
Block Arrows &Left-Right-Up Arrow 1149
Block Arrows &Bent Arrow 1152
Block Arrows &U-Turn Arrow 1153
Block Arrows &Left-Up Arrow 1150
Block Arrows &Bent-Up Arrow 1151
Block Arrows &Curved Right Arrow 1160
Block Arrows &Curved Left Arrow 1161
Block Arrows &Curved Up Arrow 1162
Block Arrows &Curved Down Arrow 1163
Block Arrows &Striped Right Arrow 1154
Block Arrows &Notched Right Arrow 1155
Block Arrows &Pentagon 1156
Block Arrows &Chevron 1157
Block Arrows &Right Arrow Callout 1164
Block Arrows &Left Arrow Callout 1165
Block Arrows &Up Arrow Callout 1166
Block Arrows &Down Arrow Callout 1167
Block Arrows &Left-Right Arrow Callout 1168
Block Arrows &Up-Down Arrow Callout 1169
Block Arrows &Quad Arrow Callout 1170
Block Arrows &Circular Arrow 1158

Stars & Banners &Explosion 1 1188
Stars & Banners &Explosion 2 1189
Stars & Banners &4-Point Star 2638
Stars & Banners &5-Point Star 1183
Stars & Banners &8-Point Star 1184
Stars & Banners &16-Point Star 1185
Stars & Banners &24-Point Star 1186
Stars & Banners &32-Point Star 1187
Stars & Banners &Up Ribbon 1180
Stars & Banners &Down Ribbon 1179
Stars & Banners &Curved Up Ribbon 1182
Stars & Banners &Curved Down Ribbon 1181
Stars & Banners &Vertical Scroll 1127
Stars & Banners &Horizontal Scroll 1128
Stars & Banners &Wave 1125
Stars & Banners &Double Wave 2639

Callouts &Rectangular Callout 1172
Callouts &Rounded Rectangular Callout 1173
Callouts &Oval Callout 1174
Callouts &Cloud Callout 1175
Callouts &Line Callout 1 1219
Callouts &Line Callout 2 1176
Callouts &Line Callout 3 1177
Callouts &Line Callout 4 1178
Callouts &Line Callout 1 (Accent Bar) 1220
Callouts &Line Callout 2 (Accent Bar) 1221
Callouts &Line Callout 3 (Accent Bar) 1222
Callouts &Line Callout 4 (Accent Bar) 1223
Callouts &Line Callout 1 (No Border) 1224
Callouts &Line Callout 2 (No Border) 1225
Callouts &Line Callout 3 (No Border) 1226
Callouts &Line Callout 4 (No Border) 1227
Callouts &Line Callout 1 (Border and
Accent Bar) 1228
Callouts &Line Callout 2 (Border and
Accent Bar) 1229
Callouts &Line Callout 3 (Border and
Accent Bar) 1230
Callouts &Line Callout 4(Border and
Accent Bar) 1110

Draw Menu on Drawing Toolbar
CommandBar Control ID
--------------------------------------------------------------------

Order Bring to Fron&t 166
Order Send to Bac&k 167
Order Bring &Forward 170
Order Send &Backward 171

Nudge &Up 1035
Nudge &Down 1036
Nudge &Left 1037
Nudge &Right 1038

Align or Distribute Align &Left 664
Align or Distribute Align &Center 668
Align or Distribute Align &Right 665
Align or Distribute Align &Top 666
Align or Distribute Align &Middle 669
Align or Distribute Align &Bottom 667
Align or Distribute Distribute &Horizontally 408
Align or Distribute Distribute &Vertically 465

Rotate or Flip Free Ro&tate 688
Rotate or Flip Rotate &Left 199
Rotate or Flip Rotate &Right 198
Rotate or Flip Flip &Horizontal 196
Rotate or Flip Flip &Vertical 197

 

[dsgs]

Sub ShowFaceIDs()
    Dim NewToolbar As CommandBar
    Dim NewButton As CommandBarButton
    Dim i As Integer, IDStart As Integer, IDStop As Integer
    
'   Delete existing FaceIds toolbar if it exists
    On Error Resume Next
    Application.CommandBars("FaceIds").Delete
    On Error GoTo 0
    
'   Add an empty toolbar
    Set NewToolbar = Application.CommandBars.Add _
        (Name:="FaceIds", temporary:=True)
    NewToolbar.Visible = True
    
'   Change the following values to see different FaceIDs
    IDStart = 1
    IDStop = 250
    
    For i = IDStart To IDStop
        Set NewButton = NewToolbar.Controls.Add _
            (Type:=msoControlButton, Id:=2950)
        NewButton.FaceId = i
        NewButton.Caption = "FaceID = " & i
    Next i
    NewToolbar.Width = 600
End Sub

http://www.j-walk.com/ss/excel/tips/tip40.htm

works great!