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

¤@¦¸²¾°£©Ò¦³¡y¶W³sµ²¡zªº¤èªk¡H

¤@¦¸²¾°£©Ò¦³¡y¶W³sµ²¡zªº¤èªk¡H

§Ú½s¿è¦nªºExcel¡A¾ã½g³£©Æº¡¡y¶W³sµ²¡z¡A¤@¤@ÂI¿ï²¾°£¡y¶W³sµ²¡z«Ü¶O¤u®É¡A
½Ð°Ýª©¤j°ª¤â¥i§_¦³¡A¤@¦¸²¾°£©Ò¦³¡y¶W³sµ²¡zªº¤èªk¡H
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

¦^´_ 1# cfuxiong

1.©óEXCEL¤¤ªº¥ô·N³B¿é¤J¤@­Ó¥ô·N­È¡]¦p¿é¤J1¡^
2.¿ï¨ú¿é¤Jªº­È¡]1¡^¡A«ö[CTRL]¤Î[C]¡]½Æ»s¡^
3.±µµÛ¿ï¨ú§t¦³¶W³sµ²ªº¸ê®Æ½d³ò
4.«ö[±`¥Î]¯Á¤Þ¼ÐÅÒ¡A¦A«ö[¶K¤W]¹Ï¥Ü«ö¶s¡A¿ï¾Ü[¿ï¾Ü©Ê¶K¤W]
5.¥X²{[¿ï¾Ü©Ê¶K¤W]µøµ¡¡A©ó[¹Bºâ]¤U¤è¿ï¾Ü[¥[/´î/­¼/°£]¡]¥ô·N¤@­Ó¡^¡A³Ì«á«ö[½T©w]
6.¦p¦¹´N¥i»´©ö§â¶W³sµ²°£¥hÅo¡A³Ñ¤Uªº¥u­n¦A§â[©³½u]°£¥h´Nok°Õ !
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 1# cfuxiong
VBAµ{§Ç
  1. Sub Ex()
  2.     Dim Sh As Worksheet        'Dim(«Å§iÅܼƬ°¨p¥ÎÅܼÆ)  «¬ºA¬° Worksheet(¤u§@ªí)
  3.     For Each Sh In Sheets      'Sheets(¤u§@ªíªº¶°¦Xª«¥ó)
  4.         Sh.Hyperlinks.Delete   'Sh(¤u§@ªí)ªºHyperlinks(¶W³sµ²¶°¦Xª«¥ó)§R°£
  5.     Next
  6. End Sub
½Æ»s¥N½X

TOP

ÁÂÁÂ¥H¤W¤G¦ìª©¤j«ü¾É...¤w¸Ñ¨M ¡F²¾°£¡y¶W³sµ²¡z§xÂZ¤F...ÁÂÁÂ~~
50 ¦r¸`¥H¤º
¤£¤ä«ù¦Û©w¸q Discuz! ¥N½X

TOP

¬Ý¨ì½׾¦³¤@­Ó¤è¦¡¤]«ÜÆg
http://gb.twbts.com/index.php?topic=3225;prev_next=next
1. "½s¿è"-"¥þ¿ï"
2. «ö CTRL + 6
À˵ø->¤u¨ã¦C->¦Û­q->«ü¥O¡@ ¿ï¾Ü ©Ò¦³«ü¥O
¨ä¤¤¦³¤@¶µ "UnlinkFields" ¬O"¸Ñ°£¥\¯àÅܼƳsµ²" ªº§@¥Î
¥¦ªº§Ö±¶Áä´N¬O ctrl + 6

TOP

¦^´_ 5# infoverdad

¨º­Ó¤èªk¬O¾A¥Î¦bWord³á!
°¶Ôйq¤l®Ñ,Åwªï§K¶O¤U¸ü°Ñ¦Ò
http://www.twbts.com/ebook/?subject=office
http://www.twbts.com/ebook/?subject=soft
°¶ÔÐÂîѮw---https://www.facebook.com/groups/669579416484096/
¦³¤@®a¬a¥J©±---https://www.facebook.com/sadodona

TOP

¦^´_ 6# °¶ÔÐ


    ¹ï­C!! ­ì¨Ó¦p¦¹. ÁÂÁ±z!!

TOP

¦^´_ 5# infoverdad


ÁÂÁ§A´£¨Ñªº«Øij¡I§Ú¥¿¦n»Ý­n¦bword¤¤¤@¦¸´N®ø°£«Ü¦h¶W³sµ²¸ê®Æ¡A§K¥h¤@­Ó¤@­Ó¸Ñ°£ªº³Â·Ð¡I

TOP

¦^´_ 8# onegirl0204


   ¤£«È®ð°Õ!!­è¦n¦³¬Ý¨ì¹L, ¤S¦³«Ü´Îªºª©¥D­Ì«üÂI¡A³o´N¬O³o­Ó½×¾Â«ÜÆgªº¦a¤è°Ú!!

TOP

¦^´_ 1# cfuxiong

¸ò¤j®a¤À¨É§Úªº°µªk
­º¥ý±NÀɮ׳]¬°¦@¥Î
µM«á±N¤u§@ªí¥þ³¡½Æ»s
¶K¨ì·sªº¤u§@ªí¡A¦¹®É¶W³sµ²À³¸Ó´N·|¥´Â_¤F
¦A¨Ó±N©³½u²¾°£¡A¨ú®ø¦@¥Î§Y¥i
Kenny

TOP

        ÀR«ä¦Û¦b : §Ñ¥\¤£§Ñ¹L¡A§Ñ«è¤£§Ñ®¦¡C
ªð¦^¦Cªí ¤W¤@¥DÃD