|
楼主 |
发表于 2020-9-6 13:19
|
显示全部楼层
在网上找了段代码,运行不了,啥原因?思路4:在工作簿模块中,综合运用隐藏的Application事件, 字典以及工作表的代码名称(CodeName)。
- Public WithEvents app As Application
- Dim dic
- Private Sub app_SheetDeactivate(ByVal Sh As Object)
- If dic.exists(Sh.CodeName) = False Then Exit Sub
- If dic(Sh.CodeName) <> Sh.Name Then
- MsgBox "你无权修改工作表名称!"
- Sh.Name = dic(Sh.CodeName)
- End If
- End Sub
- Private Sub app_SheetSelectionChange(ByVal Sh As Object, ByVal Target As Range)
- If dic.exists(ActiveSheet.CodeName) = False Then Exit Sub
- If dic(ActiveSheet.CodeName) <> ActiveSheet.Name Then
- MsgBox "你无权修改工作表名称!"
- ActiveSheet.Name = dic(ActiveSheet.CodeName)
- End If
- End Sub
- Private Sub Workbook_Open()
- dic.Add "Sheet1", "生产计划表"
- dic.Add "Sheet2", "销售计划表"
- dic.Add "Sheet3", "财务计划表"
- Set app = Application
- End Sub
复制代码 |
|