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

[µo°Ý] ­­¨îexcel ¤u§@ªí ­­¨î¦C¦L¥\¯à??

[µo°Ý] ­­¨îexcel ¤u§@ªí ­­¨î¦C¦L¥\¯à??

½Ð°Ýexcel¬O§_¦³¥i­×§ï¤u§@ªí¸ê®Æ¦ý«o¤£¯à¦C¦Lªº¥\¯à©O??
¤@ª½§ä¤£¨ì¤èªk~~¦n¶Ë¸£µ¬³á!!!!!

¦^´_ 1# pinkbabybaby

¥ÎVBA±±¨î
alt+F11¶i¤JVBE
¥ª°¼thisworkbook¼Ò²Õ§ÖÂI¥ªÁä2¤U
¿é¤J
  1. Private Sub Workbook_BeforePrint(Cancel As Boolean)
  2. Cancel = True
  3. End Sub
½Æ»s¥N½X
¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

¦^´_  pinkbabybaby

¥ÎVBA±±¨î
alt+F11¶i¤JVBE
¥ª°¼thisworkbook¼Ò²Õ§ÖÂI¥ªÁä2¤U
¿é¤J
Hsieh µoªí©ó 2012-3-16 22:29



    Hsieh ±z¦n:
   §Ú«ö±zªº¤è¦¡~~¦ý¦bworkbook  beforeprint¤U¥X²{¤W¤U¨â¦C(¦@¥|¦æ)ªºµ{¦¡½X
    ¦pªG§R±¼ªº¸Ü´N·|¸õ¦^¤@¯ë«Å§i¤U~~
    ¸Ó«ç»ò³B²z©O??¥t¥~­Y³]³o­Óµ{¦¡½X¬O¥Ã¤[ªº¶Ü??ÁÙ¬O¤@Ãö±¼­¶­±¤U¦¸¦b¶}±Ò¤S­n­«³]??
    ÁÂÁÂ!!!
   
Private Sub Workbook_BeforePrint(Cancel As Boolean)

End Sub
---------------------------------------------------------------------------------------
Private Sub Workbook_Open()

End Sub

TOP

¦^´_ 3# pinkbabybaby
³o¥u·|¦b³o­ÓÀɮפº¦³§@¥Î

¾Ç®üµL²P_¤£®¢¤U°Ý

TOP

        ÀR«ä¦Û¦b : ¥¬¬I¦p¼½ºØ¡A¥HÅw³ß¤ß´þ¼íºØ¤l¡A¤~·|µoªÞ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD