番号查询app:VBA Excel登陆窗体 补充

'已修改过

'Sheet1中
Dim t As Integer
Private Sub Worksheet_Activate()
t = t + 1
If t < 2 Then
      Worksheets(1).Visible = False
      Worksheets(2).Visible = False
      Worksheets(3).Activate
End If
End Sub

Private Sub Worksheet_Deactivate()
t = t + 1
If t < 2 Then
      Worksheets(1).Visible = False
      Worksheets(2).Visible = False
      Worksheets(3).Activate
End If
End Sub
Dim s As Integer
Private Sub Label1_Click()
If j < 1 Then
      MsgBox "尚未登陆，请先登陆！！"
      UserForm1.Show
      j = j + 1
      s = s + 1
End If
      Worksheets("sheet1").Visible = True
      Worksheets("sheet2").Visible = True
End Sub

'Sheet3中
Private Sub Worksheet_Activate()
s = s + 1
If s = 1 Then
      Worksheets("sheet1").Visible = False
      Worksheets("sheet2").Visible = False
End If
End Sub

'ThisWorkBook中
Private Sub Workbook_Open()
Worksheets("sheet1").Visible = False
Worksheets("sheet2").Visible = False
Application.Visible = False
UserForm1.Show
j = j + 1
End Sub

Private Sub Workbook_BeforeClose(Cancel As Boolean)
Worksheets("sheet1").Visible = False
Worksheets("sheet2").Visible = False
End Sub

'UserFrom1中
Private Sub CommandButton1_Click()
Dim i As Integer
Dim a As String
a = "12345"
TextBox1.SetFocus
If TextBox1 = a Then
Application.Visible = True
Worksheets(1).Visible = True
Worksheets(2).Visible = True
Unload Me
huodong
Else
Worksheets("sheet1").Visible = False
Worksheets("sheet2").Visible = False
i = i + 1
       If i >= 3 Then
           Application.Quit
       End If
End If
End Sub

Private Sub UserForm_Activate()
TextBox1.SetFocus
End Sub

Private Sub UserForm_QueryClose(Cancel As Integer, CloseMode As Integer)
If CloseMode = 0 Then
      Cancel = 1
      MsgBox "无效操作"
      End If
End Sub

'模块中
Public j As Integer
Sub huodong()
Worksheets("sheet1").Visible = False
Worksheets("sheet2").Visible = False
Worksheets(3).Activate
End Sub

'禁止删除

Private Sub Worksheet_Activate()
Dim Ctl As Office.CommandBarControl
For Each Ctl In Application.CommandBars.FindControls(ID:=847)   '847是管删除的
     Ctl.Enabled = False
Next
End Sub