将两段Private SubWorkbook_Open开头的代码分先后执行或合并 代码1: Private Sub Workbook_Open() Dimfs, d, s$ OnError Resume Next Fori = 3 To 26 Set fs = CreateObject("Scripting.FileSystemObject") Set d = fs.GetDrive(Chr(64 + i) & ":") s= d.serialnumber Select Case s Case "1219432226" Exit Sub End Select Next i MsgBox "系统将退出。" ThisWorkbook.Close False End Sub 代码2: Private Sub Workbook_Open() Application.Visible = False 系统登录.Show Sheets("用户及密码").Visible = 0 EndSub
sub 代码2()
Application.Visible = False
系统登录.Show
Sheets("用户及密码").Visible = 0
End Sub
这个要放到模块里面去
|