'■■■■■■■■■■设置“自定义工具栏”全部按钮代码开始■■■■■■■■■■
Sub auto_open() '利用自动运行宏加载创建的(自定义工具栏)命令
Dim cmd As CommandBar
Dim ctr As CommandBarControl
On Error Resume Next
Application.CommandBars("自定义工具栏").Delete
Set cmd = Application.CommandBars.Add("自定义工具栏", msoBarTop, , True)
With cmd
'设置下拉工具(父按钮一)
Set ctr = .Controls.Add(msoControlPopup)
With ctr
.Caption = "自定义排序" '下拉工具的名称
'设置下拉工具(子按钮一)
With .Controls.Add(msoControlButton)
.FaceId = 653 '此行表示(添加的图标设置,如果不需要直接注释掉即可。)
.Caption = "科室排序" '下拉工具一的名称
.OnAction = "科室排序" '执行(下拉工具一)宏命令
End With
'设置下拉工具(子按钮二)
With .Controls.Add(msoControlButton)
.FaceId = 654
.Caption = "级别排序" '下拉工具二的名称
.OnAction = "级别排序" '执行(下拉工具二)宏命令
End With
'设置下拉工具(子按钮三)
With .Controls.Add(msoControlButton)
.FaceId = 655
.Caption = "专业排序" '下拉工具三的名称
.OnAction = "专业排序" '执行(下拉工具三)宏命令
End With
'设置下拉工具(子按钮四)
With .Controls.Add(msoControlButton)
.FaceId = 656
.Caption = "性别排序" '下拉工具四的名称
.OnAction = "性别排序" '执行(下拉工具四)宏命令
End With
End With
'设置下拉工具(父按钮二)
Set ctr = .Controls.Add(msoControlPopup)
With ctr
.Caption = "年龄排序" '下拉工具的名称
'设置下拉工具(子按钮一)
With .Controls.Add(msoControlButton)
.FaceId = 210
.Caption = "年龄升序" '下拉工具一的名称
.OnAction = "年龄升序" '执行(下拉工具一)宏命令
End With
'设置下拉工具(子按钮二)
With .Controls.Add(msoControlButton)
.FaceId = 211
.Caption = "年龄降序" '下拉工具二的名称
.OnAction = "年龄降序" '执行(下拉工具二)宏命令
End With
End With
'设置单按钮一(有图标)
With .Controls.Add(msoControlButton)
.Caption = "查询系统" '单按钮的名称
.OnAction = "查询系统" '执行(单按钮)宏命令
.FaceId = 25
.BeginGroup = True
.Style = msoButtonIconAndCaptionBelow
End With
'设置单按钮二(有图标)
With .Controls.Add(msoControlButton)
.Caption = "重设条件" '单按钮的名称
.FaceId = 602
.BeginGroup = True
.OnAction = "重设条件" '执行(单按钮)宏命令
.Style = msoButtonIconAndCaptionBelow
End With
'设置单按钮三(有图标)
With .Controls.Add(Type:=msoControlButton)
.Caption = "查看数据库"
.FaceId = 707
.BeginGroup = True
.OnAction = "查看数据库"
.Style = msoButtonIconAndCaptionBelow
End With
.Visible = True
End With
End Sub
'■■■■■■■■■■设置“自定义工具栏”全部按钮代码结束■■■■■■■■■■
Private Sub Workbook_SheetActivate(ByVal Sh As Object)
Application.ScreenUpdating = False
Dim mc As CommandBarControl
Application.CommandBars("自定义工具栏").Visible = True
For Each mc In Application.CommandBars("自定义工具栏").Controls
mc.Visible = False
Next
Select Case ActiveSheet.Name
Case "统计": GoSub s0: GoSub s1: GoSub s2: GoSub s3: GoSub s4
Case "班级": GoSub s0: GoSub s2: GoSub s3: GoSub s4
Case "成绩": GoSub s4
Case "姓名": GoSub s1
Case Else: Application.CommandBars("自定义工具栏").Visible = False
End Select