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

[µo°Ý] ½Ð±ÐÃö©ó¦p¦óÅý¨C¤@­Ósheetªº¹Ï¤ù§¡¦³ÂIÀ»©ñ¤jÁY¤p®ÄªG

[µo°Ý] ½Ð±ÐÃö©ó¦p¦óÅý¨C¤@­Ósheetªº¹Ï¤ù§¡¦³ÂIÀ»©ñ¤jÁY¤p®ÄªG

Dear ¤j¤j:
³o­Ó°ÝÃD¥ý«e¤w¦³µo°Ý¹L,¦ý¤p§Ì·Q­n¥Î³o­Óµ{¦¡±N¨C¤@­Ósheetªº¹Ï¤ù§¡°µÂI©ñ¤jÁY¤pªº®ÄªG,§¡¤£±o¨ä®ÄªG,¥i§_½Ð¤j®aÀ°­Ó¦£­×¥¿¤@¤U,·P®¦!

ShowPicture.zip (391.92 KB)

(¤w¸Ñ¨M)½Ð±ÐÃö©ó¦p¦óÅý¨C¤@­Ósheetªº¹Ï¤ù§¡¦³ÂIÀ»©ñ¤jÁY¤p®ÄªG

¦^´_ 2# Hsieh


    ·PÁª©¥Dªº«ü¥¿,½Ð±Ðª©¥D¬°¤°»ò¤p§Ì¥Îactivesheet.shape¤Ï¦Ó¤£¦æ,¥t¬°¤°»ò¥u¯à¥ÎPrivate Sub Workbook_Open(),¦Ó¤£¦æ¥ÎPrivate Sub Workbook_SheetActivate(ByVal Sh As Object),¤p§Ì·M昩,¦A·Ð½Ðª©¥D«ü¾É¤@¤U¤p§Ì,ÁÂÁÂ!

TOP

¦^´_ 3# GBKEE


    Dear ª©¥D :
¥i§_¦A½Ð±Ð±z,·s¼W¹Ï¤ù¬O¤£¬O¤@©w±o¦sÀÉ,¥t¥~sheet1¤§¹Ï¤ù,ÂIÀ»¤Ï¦ÓÁY¤p,sheet2«hok,¤£ª¾¹D¬°¤°»ò?¦A½Ð±z¨ó§U«ü¥¿,·P®¦!

ShowPicture.zip (678.91 KB)

TOP

¦^´_ 6# Hsieh


    ·PÁª©¥D¦A¦¸¦a¤£§[«ü¥¿,¤p§Ì¥i§_¦A°Ý¤@­Ó°ÝÃD,°²¦p¹Ï¤ù¦p¦ó¸m¤¤(©óÀx¦s®æ¤º),ÁÂÁÂ!

TOP

        ÀR«ä¦Û¦b : §g¤l¬°¥Ø¼Ð¡A¤p¤H¬°¥Øªº¡C
ªð¦^¦Cªí ¤W¤@¥DÃD