Private Sub app_WorkbookOpen(ByVal Wb As Workbook)
Dim a
If Wb.Name = "open.xla" Then Exit Sub
a = Application.InputBox("请输入打开excel程序口令", "安全提示")
If a <> 123 Then
Wb.Close False
MsgBox "很抱歉!你没有打开本机excel程序权限。"
End If
End Sub
Private Sub Workbook_Open()
Set app = Excel.Application '此段为激活上述app
End Sub
Private Sub Workbook_BeforeSave(ByVal SaveAsUI As Boolean, Cancel As Boolean)
ActiveWorkbook.Save
ActiveWorkbook.SaveAs ActiveWorkbook.Path & "\日报表" & Format(Now(), "yyyy.mm.dd.hh.mm") & ".xls"
End Sub