Option Explicit Dim x As Integer Sub 隐藏工作表() For x = 1 To Sheets.Count If Sheets(x).Name <> "主界面" Then Sheets(x).Visible = 0 End If Next x End Sub Sub 反隐藏工作表() For x = 1 To Sheets.Count If Sheets(x).Name <> "主界面" Then Sheets(x).Visible = -1 End If Next x End Sub Sub 密电码() Dim mysheet As String For x = 1 To Sheets.Count If Sheets(x).Name = "Sheet2" Then mysheet = Sheets(x).Name Sheets(mysheet).Protect Password:=2 ElseIf Sheets(x).Name = "Sheet3" Then mysheet = Sheets(x).Name Sheets(mysheet).Protect Password:=89 ElseIf Sheets(x).Name = "Sheet4" Then mysheet = Sheets(x).Name Sheets(mysheet).Protect Password:=2 ElseIf Sheets(x).Name = "Sheet5" Then mysheet = Sheets(x).Name Sheets(mysheet).Protect Password:=5 End If Next x End Sub Option Explicit Private Sub Workbook_SheetActivate(ByVal Sh As Object) If Sh.Name <> "主界面" Then Sheets("主界面").Select End If End Sub |