Dim huizong As CommandBarPopup
Dim jisuangongzi As CommandBarControl
Dim scgzt As CommandBarControl
With Application.CommandBars("worksheet menu bar")
.Reset
Set huizong = .Controls.Add(Type:=msoControlPopup)
With huizong
.Caption = "汇总(&s)"
.BeginGroup = True
上面是我建菜单的代码,
Private Sub Worksheet_Activate()
Application.CommandBars("汇总(&s)").Visible = True
End Sub
这是我在工作表中要显示菜单的代码,但CommandBars("汇总(&s)").Visible这里有问题,请问怎么修改?谢谢