how do i find the id for menus in excel?

Are you looking for a list?

if you mean for a specific menu item, use the ID property

http://support.microsoft.com/?id=159466
Q159466 - XL97: List of ID Numbers for Built-In Command Bar Controls

http://support.microsoft.com/?id=213552
Q213552 - XL2000: List of ID Numbers for Built-In CommandBar Controls

http://support.microsoft.com/?id=215149
Q215149 - OFF2000: CommandBar Indexes Different fromOffice 97

http://support.microsoft.com/?id=162814
Q162814 - XL97: Sample Macros to Return ID for a CommandBar Control

http://support.microsoft.com/?id=213211
Q213211 - XL2000: Sample Macros to Return ID for a CommandBar Control

--
Regards,
Tom Ogilvy


"ernie" wrote:

how do i find the id for menus in excel?

Check here for a list of IDs
http://support.microsoft.com/default...b;en-us;159466
XL97: List of ID Numbers for Built-In Command Bar Controls

--
HTH

Bob Phillips

(replace somewhere in email address with gmail if mailing direct)

"ernie" wrote in message
...
how do i find the id for menus in excel?

You can also use Ole's add-in
http://www.rondebruin.nl/menuid.htm#ID

--
Regards Ron de Bruin
http://www.rondebruin.nl



"ernie" wrote in message ...
how do i find the id for menus in excel?