¿µ¼±ÀÌ¿Í ÁØ¿ì³×Áý

 

ÁØ¿ì¿Í ¿µ¼±ÀÌ³× ¿À½Å °ÍÀ» ȯ¿µÇÕ´Ï´Ù....^^

"Áö±Ý °³ÆíÁßÀÌ¿¡¿ä. ¾Èµé¾î°¡°Å³ª ¸Á°¡Áö´Â ¸Þ´º°¡ ³ª¿Ã ¼ö ÀÖ¾î¿ä."
                              È÷È÷ ÀÌ ¸»Àº º¸ÇèÀÔ´Ï´Ù...^^

M:0 / G:1

 HOME

 ÁØ¿ì³×

 ¿µ¼±À̳×

 »çÁø°ü

 ¸þ¿À¸§

 ¹æ¸í·Ï

 °Ô½ÃÆÇ

 °Ë»ö

 

 ¿ì¸®µéÀ̾߱â

 

 

 



  ÀÌÁØ¿ì(2007-12-31 14:41:26, Hit : 6469, Vote : 2200
 http://www.excellove.com/tn/board.php?board=qqqfaq&command=body&no=100
 ¿¢¼¿ ÇÏÀÌÆÛ¸µÅ©(Hyperlink) ÇÑ ¹ø¿¡ Á¦°Å

¾Æ·¡ÀÇ ¹æ¹ýÀ¸·Î ÇѲ¨¹ø¿¡ ƯÁ¤ ½ÃÆ®ÀÇ ¸ðµç ÇÏÀÌÆÛ¸µÅ©¸¦ Á¦°ÅÇÒ ¼ö ÀÖ´Ù.

1. Á¦°ÅÇÒ ÇÏÀÌÆÛ¸µÅ©°¡ ÀÖ´Â ½ÃÆ®¸¦ ¼±ÅÃÇÑ´Ù.
2. Alt + F11 ۸¦ ´­·¯ VBA ÆíÁý±â¸¦ ¿¬´Ù.
3. Ctrl + g ۸¦ ´­·¯ Á÷Á¢ ½ÇÇàâÀ» ¿¬´Ù.
4. ¾Æ·¡¿Í °°ÀÌ ÀÔ·ÂÇϰųª ¾Æ·¡ ±¸¹®À» º¹»çÇØ Á÷Á¢½ÇÇàâ¿¡ ºÙ¿©³ÖÀº µÚ Enter¸¦ ´©¸¥´Ù
ActiveSheet.Hyperlinks.Delete
3. Alt + q ۸¦ ´­·¯ VBAÆíÁý±â¸¦ ´Ý°í ¿¢¼¿·Î µÇµ¹¾Æ °£´Ù.

ÅëÇÕ¹®¼­ÀÇ ¸ðµç ÇÏÀÌÆÛ¸µÅ©¸¦ Á¦°ÅÇÏ·Á¸é ¾Æ·¡¿Í °°Àº ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÑ´Ù.
1. Alt + F11 ۸¦ ´­·¯ VBA ÆíÁý±â¸¦ ¿¬´Ù.
2. Alt + i + mÀ» ´©¸£°Å³ª »ðÀÔ ¸Þ´ºÀÇ ¸ðµâÀ» ¼±ÅÃÇØ, ¸ðµâÀ» Ãß°¡ÇÑ´Ù.
3. ¾Æ·¡ÀÇ Äڵ带 ÀÔ·ÂÇϰųª º¹»çÇØ ºÙ¿©³Ö±â ÇÑ´Ù.
Sub dhDeleteAllHyperLinks()
Dim s As Object
For Each s In Sheets
    s.Hyperlinks.Delete
Next s
End Sub
4. F5۸¦ ´­·¯ dhDeleteAllHyperLinks¶ó´Â ÇÁ·Î½ÃÀú¸¦ ½ÇÇàÇÑ´Ù

»ðÀÔÇÑ ¸ðµâÀÌ ÇÊ¿äÇÏÁö ¾ÊÀº °æ¿ì ÇØ´ç ¸ðµâÀ» »èÁ¦ÇÑ´Ù.
»èÁ¦ÇÏ´Â ¼ø¼­´Â ´ÙÀ½°ú °°´Ù.

1. º¸±â ¸Þ´º¿¡¼­ ÇÁ·ÎÁ§Æ® Ž»ö±â ¼±ÅÃÇϰųª Ctrl + r¸¦  ´­·¯ ÇÁ·ÎÁ§Æ® Ž»ö±â¸¦ ¿¬´Ù
2. »èÁ¦ÇÏ·Á´Â ¸ðµâÀ» ¼±ÅÃÇÑ´Ù. ÇØ´ç ¸ðµâÀÌ º¸ÀÌÁö ¾ÊÀ¸¸é + ۸¦ ´­·¯ ÇÁ·ÎÁ§Æ®¸¦ È®ÀåÇÑ´Ù.
3. ¸¶¿ì½º ¿À¸¥ÂÊ ´ÜÃ߸¦ ´­·¯ ¸ðµâ Á¦°Å¸¦ ¼±ÅÃÇÑ´Ù.
4. Á¦°ÅÇϱâ Àü¿¡ ÇØ´ç ¸ðµâÀ» ³»º¸³»±âÇϰڴÀ³Ä´Â ´ëÈ­»óÀÚ°¡ Ç¥½ÃµÇ¸é ¾Æ´Ï¿À¸¦ ¼±ÅÃÇÑ´Ù.(À̶§ ¿¹¸¦ ¼±ÅÃÇÏ¸é ¸ðµâÀ» º°µµÀÇ ÆÄÀÏ·Î ÀúÀåÇÏ°Ô µÈ´Ù.)




¡â ÃÖ´ëÀýÀü¸ðµå ¼³Á¤
¡ä ¿¢¼¿ 2002 ´ÜÃà Ű

Copyright 1999-2025 Zeroboard / skin by zero
 

 

 

ÁØ¿ì¿Í ¿µ¼±ÀÌ³× Áý

°ü¸®ÀÚ ÀüÀÚ¿ìÆí: joonwoo@hitel.net


Warning: Unknown(): Your script possibly relies on a session side-effect which existed until PHP 4.2.3. Please be advised that the session extension does not consider global variables as a source of data, unless register_globals is enabled. You can disable this functionality and this warning by setting session.bug_compat_42 or session.bug_compat_warn to off, respectively. in Unknown on line 0