ªð¦^¦Cªí ¤W¤@¥DÃD µo©«

[µo°Ý] EXCEL³]©w¬Y¤é´Á¨ìÀÉ®×µLªk¶}±Ò

¦^´_ 40# luhpro


§Ú§â¥H¤U¦r¦ê³£©ñ¶i¥h¤F,³o¼Ë¤£¹ï¶Ü¡H½Ð¬Ý§Úªº¹Ï¤ù,³£¦³¶i¥h§r~  

Private Sub Workbook_Open()

  If Date > #5/11/2015# Then §R°£¦Û¤v

End Sub
¤p«B

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2015-5-15 01:31 ½s¿è
¦^´_  luhpro
§Ú§â¥H¤U¦r¦ê³£©ñ¶i¥h¤F,³o¼Ë¤£¹ï¶Ü¡H½Ð¬Ý§Úªº¹Ï¤ù,³£¦³¶i¥h§r~  
Private Sub Work ...
hueywen_jia µoªí©ó 2015-5-14 21:07

©³¤U®ç¬õ¦â³o¤@¶ô  (§R°£¦Û¤v)µ{§Ç¹êÅé ¤]­n©ñ¶i¥h,
Workbook_Open ¤¤ Then «á­±ªº §R°£¦Û¤v «ü¥O¤~©I¥sªº¨ì ¸Óµ{§Ç ³á:

Public Sub §R°£¦Û¤v()

    ThisWorkbook.Saved = True

    ThisWorkbook.ChangeFileAccess Mode:=xlReadOnly

    Kill ThisWorkbook.FullName

    ThisWorkbook.Close SaveChanges:=False

End Sub


Private Sub Workbook_Open()

  If Date > #5/28/2115# Then
§R°£¦Û¤v  ' ¤µ¤Ñ¬°¦¹¤é´Á®É, §R°£¥»ÀÉ®×, ª`·N : ÀɮקR°£«áµLªk´_­ì, ´ú¸Õ®É½Ð°È¥²¥ý³Æ¥÷¥»ÀÉ®×.
End Sub

TOP

¦^´_ 42# luhpro


   ²×©ó¦¨¥\¤F!!¡@·PÁ luhpro¡@ªº¤j¤O¨ó§U¡I¡@¤£Ä@¨ä·ÐªºÀ°§Ú¸Ñµª¡ã¦]¬°¥¨¶°ªº¤åªk¯uªº¤£·|¡A¤£´¿¾Ç¹L¡A³£¥u¦³¥Î¿ý»sªº¤è¦¡¨Ó¼g¥¨¶°¡A¯u¬O·P¿E¤£ºÉ¡I¡I¡@¦A¦¸ÁÂÁ§A¡I¡ã
¤p«B

TOP

¦^´_  hueywen_jia
    ¥t¥~¥i§_½Ð¦³Åv­­ªº¤j¤jÀ°§Ú§R°£§Úªþ¥óªºÀ£ÁYÀÉ©O(¦b²Ä¤G­¶¤U¤èWENWENWENWENW ...
hueywen_jia µoªí©ó 2015-5-16 00:39


¤U¦¸¤W¶Çªº½d¨ÒÀÉ®×,
¥i¥H°u±¡±N°Q½×¦ê¤¤¥Î¤£¨ìªº³¡¤À¤u§@ªí§R°£,
°Q½×·|¥Î¨ìªº¸ê®Æ¥i¥H°u±¡¨ú¥Î¥Nªí©Êªº¤å¦r,
­Y¬O¤H¦Wµ¥¥i¯àIJ¥Ç¨ì­Ó¸êªkªº¸ê®Æ«h°u¤©Mark(¨Ò¦p : ¤ýxx¡B§õ¤@¤@...µ¥)©Î¬O¥Î±i¤T¡B§õ¥|¡B¤ý¬ü¤kµ¥´À¥N,
µ½¥Î ½s¿è->¨ú¥N ¥\¯à´N¥i¥H«Ü¤è«K¹F¦¨¦¹¥Øªº,
¤£¹L­n¯d·N¾A·í¦w±Æ¦n¥ý«á¶¶§Ç,
¨Ò¦p­Y¥ý¥Î 5 ¨ú¥N 3,
¤§«á´N¤£¾A©y¥Î 7 ¨ú¥N 5.(¥i¯à·|¯}Ãa¸ê®Æªº°ß¤@©Ê)

Á`¤§­n´£¨Ñ«ç»ò¼Ë¤º®eªº½d¨ÒÀÉ®×­n¬Ý°Q½×ªº¥Øªº»P»Ý¨D.

TOP

        ÀR«ä¦Û¦b : ·O´d¨S¦³¼Ä¤H¡A´¼¼z¤£°_·Ð´o¡C
ªð¦^¦Cªí ¤W¤@¥DÃD