OfficeTutor.com
Home ·Î±×ÀΠȸ¿ø°¡ÀÔ °í°´¼¾ÅÍ »çÀÌÆ®¸Ê
½ÃÀÛÆäÀÌÁö¼³Á¤ Áñ°Üã±âÃß°¡
¹è¿òÅÍ ³ª´®ÅÍ ±³À° MY¿ÀÆ©
 
¡¡ Home > ¹è¿òÅÍ > ¹«·á°­ÁÂ
¡¡

  

10. ÇÏÀÌÆÛ¸µÅ© »èÁ¦

ÀÚ·á´Ù¿î·Îµå : ¿ÀÆ©°ø±¸ÇÔ010.xls 

¾È³çÇϼ¼¿ä ¿ÀÆ©°¡Á· ¿©·¯ºÐ

¿À´ÃÀº ÇÏÀÌÆÛ¸µÅ©¸¦ »èÁ¦ÇÏ´Â ±â´ÉÀ» Ãß°¡ÇÏ·Á°í ÇÕ´Ï´Ù. ÇÏÀÌÆÛ¸µÅ©¸¦ »èÁ¦Çϱâ Àü¿¡ Âü°í·Î ¸¸µå´Â ¹æ¹ýÀ» »ìÆ캸ÁÒ(Âü°í·Î ¿ÀÇǽº97¹öÀüÀ» ±âÁØÀ¸·Î ¼³¸íÇÕ´Ï´Ù) ¸ÅÅ©·Î ±â·Ï±â¸¦ »ç¿ëÇÏ¿© ÇÏÀÌÆÛ¸µÅ©¸¦ Ãß°¡ÇÏ¸é ´ÙÀ½°ú °°Àº Äڵ带 º¼ ¼ö ÀÖ½À´Ï´Ù. 

ActiveSheet.Hyperlinks.Add Anchor:=Selection, Address:= _
http://www.officetutor.co.kr/ 

ÇöÀç½ÃÆ®ÀÇ ÇÏÀÌÆÛ¸µÅ©°³Ã¼¿¡¼­ Add¸Þ¼Òµå¸¦ »ç¿ëÇÏ¿© Ãß°¡Çϴµ¥, ÇÏÀÌÆÛ¸µÅ©¸¦ Ãß°¡Çϱâ À§ÇÑ Á¤º¸´Â Anchor¿Í Address ÀÔ´Ï´Ù. Anchor´Â ÇÏÀÌÆÛ¸µÅ©¸¦ °¡Áö´Â ºÎºÐÀÌ°í Address´Â ÇÏÀÌÆÛ¸µÅ©ÀÇ ´ë»óÀÔ´Ï´Ù. ¹°·Ð Anchor´Â Range ¶Ç´Â Shape°³Ã¼¸¦ ÁöÁ¤ÇØ¾ß Çϸç, Address ´Â ¹®ÀÚ¿­·Î¼­ ÀÎÅͳÝÁÖ¼Ò, ¸ÞÀÏÁÖ¼Ò, ¹®¼­ÀÇ À§Ä¡ µîÀÌ µÉ ¼ö ÀÖ½À´Ï´Ù. µµ¿ò¸»À» ã¾Æº¸´Ï Àç¹ÌÀÖ´Â ¿¹Á¦°¡ ÀÖ±º¿ä. Çѹø º¼±î¿ä!

                  For Each h in Worksheets(1).Hyperlinks
                       If Instr(h.Name, "microsoft") <> 0 Then h.Follow
                  Next


À§ÀÇ ¿¹´Â 1¹ø ¿öÅ©½ÃÆ®³»ÀÇ ¸ðµç ÇÏÀÌÆÛ¸µÅ©¸¦ °¢°¢ °Ë»çÇÏ¿© "microsoft"¶ó´Â ´Ü¾î¸¦ °¡Áö¸é Follow¸Þ¼Òµå¸¦ »ç¿ëÇÏ¿© ÇØ´çURL·Î À̵¿ÇÏ´Â ¿¹ÀÔ´Ï´Ù. ÀÌÁ¦ ÇÏÀÌÆÛ¸µÅ©¸¦ »èÁ¦Çغ¸µµ·Ï ÇսôÙ. À§ÀÇ Äڵ带 ±â¹ÝÀ¸·Î ¾Æ·¡¿Í °°ÀÌ Delete¸Þ¼Òµå¸¦ »ç¿ëÇÏ¸é µÉ °Í °°½À´Ï´Ù.

                 Sub DeleteHyperLink()
                          Dim h As Hyperlink

                          For Each h In ActiveSheet.Hyperlinks
                                    h.Delete
                          Next
                End Sub


¸Å¿ì °£´ÜÇÕ´Ï´Ù. ¿©±â¿¡ ±â´ÉÀ» ´õ¿í ºÎ°¡ÇÏÀÚ¸é MsgBoxÇÔ¼ö¸¦ »ç¿ëÇÏ¿© ÀÏÀÏÀÌ »ç¿ëÀÚÀÇ È®ÀÎÀ» ¹Þ°Ô ÇÒ ¼öµµ ÀÖÁÒ. 

¿À´ÃÀº ¿©±â±îÁöÀÔ´Ï´Ù. 

¸ñÂ÷ | ÀÌÀü | ´ÙÀ½

¡¡

ȸ»ç¼Ò°³ | ÀÌ¿ë¾à°ü | °³ÀÎÁ¤º¸ º¸È£Á¤Ã¥ | ȸ¿øÁ¤º¸¼öÁ¤ | ±³À°½Åû ¹× ¹®ÀÇ | À̸ÞÀϹ«´Ü¼öÁý°ÅºÎ 
   (¿ì)143-721 ¼­¿ï ±¤Áø±¸ ±¸Àǵ¿ 546-4 Å×Å©³ë¸¶Æ® 26Ãþ6È£
¢ß¿ÀÇǽºÆ©ÅÍ ¢Ï1544-4102  ´ëÇ¥ÀÌ»ç : Àü°æ¼ö
°³ÀÎÁ¤º¸°ü¸®Ã¥ÀÓÀÚ : ÀÌÈñÁø(privacy@officetutor.com)
»ç¾÷ÀÚµî·Ï¹øÈ£ 120-86-14501 Åë½ÅÆǸž÷½Å°í ±¤Áø1501È£
 
Copyright ¨Ï OfficeTutor.com ÀÌ ÆäÀÌÁöÀÇ ÀúÀÛ±ÇÀº ¢ß¿ÀÇǽºÆ©ÅÍ¿Í ÄÁÅÙÃ÷ Á¦°øÀÚ¿¡°Ô ÀÖ½À´Ï´Ù. ¹«´Ü º¹Á¦¸¦ ±ÝÇÕ´Ï´Ù.
Microsoft ¹× Office ·Î°í´Â ¹Ì±¹, ´ëÇѹα¹ ¹×/¶Ç´Â ±âŸ ±¹°¡¿¡¼­ÀÇ Microsoft Corporation µî·Ï »óÇ¥ ¶Ç´Â »óÇ¥ÀÔ´Ï´Ù.