Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
This code is throwing nothing but errors in VBA:
Private WithEvents objCommandBarButton As CommandBarButton Private Sub Workbook_Open() Dim obkCommandbars As CommandBars Dim objCommandBar As CommandBar Dim objCommandBarControl As CommandBarControl ' Create a menu command on the "Tools" menu. objCommandBars = Me.Application.CommandBars("Tools") objCommandBar = objCommandBars.Item("Tools") ' Make sure menu command doesn't already exist. For Each objCommandBarControl In objCommandBar.Controls If objCommandBarControl.Caption = "Perform Metric conversion..." Then objCommandBar.Controls.Item("Perform Metric conversion...").Delete End If Next objCommandBarControl objCommandBarButton = objCommandBar.Controls.Add(msoControlButton) With objCommandBarButton .Caption = "Perform Metrics Conversion..." .Style = msoButtonCaption .Tag = "Perform Metrics Conversion..." .OnAction = "!<Magic_Metrics.Connect" .Visible = True End With End Sub AM I missing something here? Jody W |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Missing MB | Excel Discussion (Misc queries) | |||
Something Missing | Excel Worksheet Functions | |||
Toolbars Missing, And option to Add Missing | Excel Discussion (Misc queries) | |||
What am I missing here...? | Excel Programming | |||
I'm missing something here.... | Excel Programming |