Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
Hi all
1. I want to add a control before "&Fill Color" on the Formatting commandbar. I'm stuck and frustrated! In this effort "After:=FontCtrl" is clearly wrong Sub Test() Dim FontCtrl As Object With Application.CommandBars("Formatting") Set FontCtrl = .FindControl(Id:=1691) '1691 is Fill Color ID 'MsgBox FontCtrl.Caption .Controls.Add(Type:=msoControlButton, _ after:=FontCtrl).Caption = "MyCaption" 'fails 'also .OnAction, .Tag etc End With End Sub 2. I've noticed some customized toolbars extend to the right of the screen. What would be the best approach to ensure I am neither putting my new control, nor pushing any others off the screen. TIA, Dan |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
In-place CommandBar.Add run-time error | Excel Discussion (Misc queries) | |||
commandbar problems | Excel Discussion (Misc queries) | |||
Disabling Toolbar buttons and CommandBar items | Excel Programming | |||
Commandbar button running macro | Excel Programming | |||
Controlling Font Name in a personnal Commandbar | Excel Programming |