Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Using VBA I am trying to add a simple button to CommandBars(1). The
result of the code below is the button is created but the Caption is missing. From the immediate window, the Caption Property contains the value I assigned in the code, it just refuses to display on the toolbar. This has worked for me hundreds of times in XL2k. Can you help? Sub AddUCXButton() ' On Error Resume Next DeleteUCXButton Dim MenuObject Set MenuObject = Application.CommandBars(1). _ Controls.Add(Befo=11, _ Type:=msoControlButton, Temporary:=True) MenuObject.Caption = "&UCX830" MenuObject.OnAction = "RunAMacro" End Sub TIA Ror |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
XL2007 and XL2003 | Excel Discussion (Misc queries) | |||
How to increase size of image in button (msocontrolbutton) of custom toolbar of Excel | Excel Discussion (Misc queries) | |||
XL2003 Add Ins | Excel Programming | |||
xl2003 and VS | Excel Programming | |||
xl2003 | Excel Programming |