|
楼主 |
发表于 2013-6-28 21:09
|
显示全部楼层
hwc2ycy 发表于 2013-6-28 21:07
我都用了的,你看范例,这可不是忽你的,
你添加的是啥类型的。 Sub AUTO_OPEN()
Dim MyBar As CommandBar, ButtonNewTable
Set MyBar = CommandBars.Add("hoo", msoBarTop, False, True)
MyBar.Visible = True
With MyBar
'.RowIndex = msoBarRowFirst
.RowIndex = msoBarRowLast
.Left = 1
End With
Set ButtonNewTable = MyBar.Controls.Add(Type:=msoControlButton, ID _
:=23, Before:=1)
With ButtonNewTable
.Style = msoButtonIconAndWrapCaptionBelow
.FaceId = 17
.Caption = "第一个"
.OnAction = "NewTableInfo_Show"
End With
End Sub
这是我附件的代码 ,要怎么改?
|
|