Granular Control of the Analysis Context Menu - Part 5

[Former Member]

This article provides information on Control IDs for specific Excel commands on the Cell Context menu in Excel. For an overview of this series of articles, please see the first article in the series, here: Granular Control of the Analysis Context Menu - Part 1

As per per the example in Granular Control of the Analysis Context Menu - Part 3, we can find Excel CommandBarControls by searching for specific ID property values. Excel assigns unqiue ID properties to each of the Excel CommandBarControls, so I've summarised them below. They're largely common to Excel 2007 and 2010, but I include differences where they exist. I only list the caption/ID for 2010 if it is new or different*.

2007 Caption                2007 ID  2010 Caption*        2010 ID*

=========================== =======  ==================== ========

Cu&t                             21

&Copy                            19

&Paste                           22

Paste &Special...               755                        21437

                                     &Paste Table           3624

&Insert...                     3181

&Delete...                      292

Clear Co&ntents                3125

                                     Sp&arkline            31623

Filt&er                       31402

S&ort                         31435

Insert Co&mment                2031

Delete Co&mment                1592

Sh&ow/Hide Comments            1593

&Format Cells...                855

Pic&k From Drop-down List...   1966

&Show Phonetic Field           1614

Name a &Range...              13380  Define N&ame...            

&Hyperlink...                  1576

Edit &Hyperlink...             1577

&Open Hyperlink                1015

&Remove Hyperlink              3626

E&xpand to detail             11299

Additional Act&ions           31595

F&ull Screen                    178

                                     &Additional Actions   22577

Note the differences between Excel 2007 and Excel 2010:

1. There are 3 new commands in 2010.

2. As a result of the new commands in 2010, there are now 2 very similarly named commands:

    - "Additional Act&ions" - Is the same as 2007, with ID 31595

    - "&Additional Actions" - Is new in 2010, with ID 22577

3. "Name a &Range..." becomes "Define N&ame..." in 2010.

4. The ID for "Paste &Special..." changes from 755 in 2007, to 21437 in 2010.