Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
List of CommandBars & Control IDs
Hi
Does any one have a list or know how I might access one for the EXCEL 2000 and 2003 commandbars and control IDs. In particular, I need the ID for the Format Painter button and Copy button in both 2003 and 2000. Thank you, Silena |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
List of CommandBars & Control IDs
Have a look here
http://support.microsoft.com/kb/213552 Mike "Silena K-K" wrote: Hi Does any one have a list or know how I might access one for the EXCEL 2000 and 2003 commandbars and control IDs. In particular, I need the ID for the Format Painter button and Copy button in both 2003 and 2000. Thank you, Silena |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
List of CommandBars & Control IDs
See
http://www.rondebruin.nl/menuid.htm Ole's add-in is very useful -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Silena K-K" wrote in message ... Hi Does any one have a list or know how I might access one for the EXCEL 2000 and 2003 commandbars and control IDs. In particular, I need the ID for the Format Painter button and Copy button in both 2003 and 2000. Thank you, Silena |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
List of CommandBars & Control IDs
Open a blank workbook and place the cell pointer at cell A1 of Sheet1.
Press Alt+F11 to open the VBE and then click on INSERT in the menu and select MODULE. Type or copy/paste the following code in the module Sub ControlID() Dim cb As CommandBar Dim ctl As CommandBarControl Dim lngRO As Long For Each cb In Application.CommandBars For Each ctl In cb.Controls With Application.ActiveCell .Offset(lngRO).Value = cb.Name .Offset(lngRO, 1).Value = ctl.ID .Offset(lngRO, 2).Value = ctl.Caption End With lngRO = lngRO + 1 Next ctl Next cb Set cb = Nothing Set ctl = Nothing End Sub Starting in cell A1 in will list Command Bar name in column A, the button's control ID on the command bar in column B and place the command button caption in column C. With the cursor somewhere in the code press F5 while in the VBE to execute, or return to the workbook and Click TOOLS in the menu, select MACRO, MACROS. Select the macro ControlID and click the RUN command button Hope this helps -- Kevin Backmann "Silena K-K" wrote: Hi Does any one have a list or know how I might access one for the EXCEL 2000 and 2003 commandbars and control IDs. In particular, I need the ID for the Format Painter button and Copy button in both 2003 and 2000. Thank you, Silena |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
List of CommandBars & Control IDs
Hi Mike, Ron & Kevin
Thank you for your help - I have to try this at work and unfortunately IT have blocked my access to asking/responding to questions in the Discussion Group forum so I'll let you know how I got on in about 10 hours! Thanks again, Silena "Silena K-K" wrote: Hi Does any one have a list or know how I might access one for the EXCEL 2000 and 2003 commandbars and control IDs. In particular, I need the ID for the Format Painter button and Copy button in both 2003 and 2000. Thank you, Silena |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
List of CommandBars & Control IDs
Hi Mike
When I clicked on this link it came up with Access Denied. See Cache Administrator. Do you know what that means?? Thanks Silena "Mike H" wrote: Have a look here http://support.microsoft.com/kb/213552 Mike "Silena K-K" wrote: Hi Does any one have a list or know how I might access one for the EXCEL 2000 and 2003 commandbars and control IDs. In particular, I need the ID for the Format Painter button and Copy button in both 2003 and 2000. Thank you, Silena |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Add list in Control Combo Box | Excel Discussion (Misc queries) | |||
Saving CommandBars | Excel Discussion (Misc queries) | |||
List of Control functions | Excel Worksheet Functions | |||
List control | Excel Discussion (Misc queries) | |||
format control of a list box | Excel Worksheet Functions |