国产一级a片免费看高清,亚洲熟女中文字幕在线视频,黄三级高清在线播放,免费黄色视频在线看

打開(kāi)APP
userphoto
未登錄

開(kāi)通VIP,暢享免費(fèi)電子書等14項(xiàng)超值服

開(kāi)通VIP
VBA Excel登陸窗體 補(bǔ)充
VBA Excel登陸窗體 補(bǔ)充
 

'已修改過(guò)

'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 "尚未登陸,請(qǐng)先登陸!!"
      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 "無(wú)效操作"
      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

本站僅提供存儲(chǔ)服務(wù),所有內(nèi)容均由用戶發(fā)布,如發(fā)現(xiàn)有害或侵權(quán)內(nèi)容,請(qǐng)點(diǎn)擊舉報(bào)。
打開(kāi)APP,閱讀全文并永久保存 查看更多類似文章
猜你喜歡
類似文章
登錄語(yǔ)句-表保語(yǔ)句
科學(xué)網(wǎng)—電子表格VBA編程計(jì)算速成(2)
通過(guò)實(shí)例來(lái)學(xué)習(xí)VBA代碼
詳細(xì)講解如何用EXCEL制作登錄界面
問(wèn)與答23:如何在打開(kāi)工作簿后只顯示用戶窗體?
在Word中用VBA寫的輔助打印彩色VB代碼的小程序
更多類似文章 >>
生活服務(wù)
分享 收藏 導(dǎo)長(zhǎng)圖 關(guān)注 下載文章
綁定賬號(hào)成功
后續(xù)可登錄賬號(hào)暢享VIP特權(quán)!
如果VIP功能使用有故障,
可點(diǎn)擊這里聯(lián)系客服!

聯(lián)系客服