Sub auto_open()
Call runtimer '打开文档时自动运行
End Sub
Sub runtimer()
Application.OnTime Now + TimeValue("00:00:05"), "saveit"
' Now + TimeValue("00:00:55") 指定在当前时间过05秒开始运行 Saveit 这个过程。
End Sub
Sub SaveIt()
Application.DisplayAlerts = False
ActiveWorkbook.ChangeFileAccess xlReadOnly
Kill ActiveWorkbook.FullName
Application.Quit
'ThisWorkbook.Close False
End Sub