·íµM§A¥²¶·¼g¤@¥¨¶°¡A§Q¥Î±K½X¨Ó´x±±¥i§_¨Ï¥Î
¦b Workbook_OpenÃö³¬¨Ï¥Î¦p¤U
Private Sub Workbook_Open()
Worksheets("¤u§@ªí1").CommandButton1.Enabled = False
End Sub
¤U¦A§Q¥Î¥¨¶°¨Ó±Ò¥Î¥¦
Private Sub pas_Click()
aa = InputBox("½Ð¿é¤J±K½X")
pass = "12345"
If aa = pass Then
CommandButton1.Enabled = False
End If
End Sub
aa = InputBox("½Ð¿é¤J±K½X")
pass = "12345"
If aa = pass Then
CommandButton1.Enabled = True
Else
CommandButton1.Enabled = False
MsgBox "¿ù»~¿é¤J"
Exit Sub
End If
§AÀ³¸Ó¬Ý²M·¡2¼Óªº¸Ñ»¡¡A
CommandButton1.Enabled = False'¬°¤£¥i¨Ï¥Î¡A·|Åܦ¨¦Ç¦âªº
CommandButton1.Enabled =True'¬°¥i¨Ï¥Î¡A·|¦¨¬°¥¿±`¥i¨Ï¥Î±¡ªp
¡A¦Ó2¼Óªº¨Ò¤l
¦b Workbook_Open®É¡A·|Ãö³¬«ö¶sªº¨Ï¥Î¡Aª½¨ì°õ¦æpasµ{¦¡®É¤è¥i¸Ñ¶}«ö¶sªº¨Ï¥Î
Private Sub Workbook_Open()
Worksheets("¤u§@ªí1").CommandButton1.Enabled = False
End Sub
¤U¦A§Q¥Î¥¨¶°¨Ó±Ò¥Î¥¦
Private Sub pas_Click()
aa = InputBox("½Ð¿é¤J±K½X")
pass = "12345"
If aa = pass Then
CommandButton1.Enabled = True'±K½X¹ï®É¡A«hCommandButton1«ö¶sÅÜ¥i¥H¨Ï¥Î¡A
Else
CommandButton1.Enabled = False'±K½X¿ù»~®É¡A«hCommandButton1«hºû«ù¤£²Õ¨Ï¥Î¡A«ö¶s¬°¦Ç¦âªº
MsgBox "¿ù»~¿é¤J"
Exit Sub'±K½X¿ù»~®É¸õ¥Xµ{¦¡¡A¬Æ¦Ü¤£¯à°õ¦æ¤U±µ{¦¡
End If