Office XP CommandBars ¸¶½ºÅ© ¹× ±×¸² ¼Ó¼º ¼³Á¤ ¹æ¹ý

±â¼ú ÀÚ·á: 286460 - ÀÌ ¹®¼­°¡ Àû¿ëµÇ´Â Á¦Ç° º¸±â.
¸ðµÎ È®´ë | ¸ðµÎ Ãà¼Ò

ÀÌ ÆäÀÌÁö¿¡¼­

¿ä¾à

Microsoft Office XP CommandBarButton °³Ã¼¿¡ µÎ °³ÀÇ »õ ¼Ó¼ºÀ» ¼Ò°³ÇÕ´Ï´Ù: ¸¶½ºÅ© ¹× ±×¸² ¼Ó¼ºÀ». ÀÌ·¯ÇÑ ¼Ó¼ºÀº ±×¸²ÀÌ »ý¼ºµÈ »ç¿ëÀÚ ÁöÁ¤ ¸í·É ¸ðÀ½ ÄÁÆ®·ÑÀ» ¹èÄ¡ÇÒ ¼ö ÀÖ½À´Ï´Ù.

Âü°í ÀÌ·¯ÇÑ ¼Ó¼ºÀ» Microsoft Office 2003¿¡¼­ »ç¿ëÇÒ ¼ö ÀÖ½À´Ï´Ù.

Ãß°¡ Á¤º¸

Mask ¹× ±×¸² ¼Ó¼ºÀº Stdole ¶óÀ̺귯¸®ÀÇ ¸â¹ö ÀÎ IPictureDisp, Çü½ÄÀ¸·Î Á¤Àǵ˴ϴÙ. IPictureDisp ÇÁ·Î¼¼½º °æ°è¿¡ °ÉÃÄ ¹è¿­µÈ ¼ö ¸Þ¼­µå¸¦ »ç¿ëÇÕ´Ï´Ù. µû¶ó¼­, ¸¶½ºÅ© ¹× ±×¸² ¼Ó¼ºÀ» ´ëÇØ¼­¸¸ in-process È£ÃâÇÒ ¼ö ÀÖ½À´Ï´Ù (VBA ¸ÅÅ©·Î¸¦, ÀÚµ¿È­ Ãß°¡ ±â´É ¹× ActiveX DLLÀ» ÇÁ·Î¼¼½º ½ÇÇà). ÀÌ µ¿ÀÛ¿¡ ´ëÇÑ ÀÚ¼¼ÇÑ ³»¿ëÀº "ÂüÁ¶" ÀýÀ» ÂüÁ¶ÇϽʽÿÀ.

¾Æ·¡ ¿¹Á¦¿¡¼­´Â ÀÚµ¿È­ Ãß°¡ ¸¶½ºÅ©µÈ ±×¸²À¸·Î CommandBar ´ÜÃ߸¦ Ãß°¡ÇÏ´Â ±â´É¿¡¼­ ¸¸µå´Â ¹æ¹ýÀ» º¸¿© ÁÝ´Ï´Ù.

±×¸² ¹× »ç¿ëÇÏ¿© ¸¶½ºÅ© À̹ÌÁö¸¦ ¸¸µå´Â ´Ü°è

  1. Microsoft ±×¸²ÆÇ ½ÃÀÛÇϽʽÿÀ. À̹ÌÁö ¸Þ´º¿¡¼­ ¼Ó¼º À» Ŭ¸¯ÇϽʽÿÀ. 32 x 32 À̹ÌÁö Å©±â¸¦ º¯°æÇÑ ´ÙÀ½ È®ÀÎ À» Ŭ¸¯ÇϽʽÿÀ.
  2. ³ë¶õ»ö Ç¥¸é ±×¸®±â È­¸é¿¡ ±×¸³´Ï´Ù. ÆÄ¶õ»ö ¿øÀ¸·Î ÁÖº¯ ¿µ¿ªÀ» ä¿ó´Ï´Ù.

    ±×¸² Ãà¼Ò±×¸² È®´ë
    Picture of sample Picture.bmp. Steps
				to re-create this image are given in this article.
  3. À̹ÌÁö¸¦ Circle.bmp ÆÄÀÏ·Î ÀúÀåÇϽʽÿÀ.
  4. ¸¶½ºÅ©¸¦ ¸¸µé·Á¸é ÇÔ²² °ËÁ¤ ¿ø ä¿ì°í ¿ø ¹Û¿¡¼­ ¿µ¿ªÀ» Èò»öÀ¸·Î ä¿ì±â. ¸¶½ºÅ©°¡ ±×¸² CommandBar ÄÁÆ®·Ñ¿¡ Ãß°¡µÉ ¶§ Èò»ö ¿µ¿ªÀº Åõ¸íÇÑ µ¿¾È¿¡´Â ¸¶½ºÅ©ÀÇ °ËÁ¤ ¿µ¿ª Ç¥½ÃµË´Ï´Ù.

    ±×¸² Ãà¼Ò±×¸² È®´ë
    Picture of sample Mask.bmp. Steps to
				re-create this image are given in this article.
  5. À̹ÌÁö¸¦ Mask.bmp ÆÄÀÏ·Î ÀúÀåÇϽʽÿÀ.

COM AddIn ¸¸µå´Â ´Ü°è


  1. Visual Basic ½ÃÀÛÇÏ°í »õ AddIn ¸¸µé ÇÁ·ÎÁ§Æ®.
  2. ÇÁ·ÎÁ§Æ® ¸Þ´º¿¡¼­ ÂüÁ¶ ¸¦ ´©¸¨´Ï´Ù. "Office Çü½Ä ¶óÀ̺귯¸®¸¦ °æ¿ì XP ¼±ÅÃÇÑ ¹öÀüº¸´Ù ÀÌÀü, ÀÏ¹Ý ÇØ´ç Çü½Ä ¶óÀ̺귯¸® ¹× Microsoft Office XP¿¡ ´ëÇÑ Çü½Ä ¶óÀ̺귯¸®¸¦ ¼±ÅÃÇÕ´Ï´Ù. È®ÀÎ À» Ŭ¸¯ÇϽʽÿÀ.
  3. ÇÁ·ÎÁ§Æ® Ž»ö±â¿¡¼­ frmAddin ¸¶¿ì½º ¿À¸¥ÂÊ ´ÜÃ߷ΠŬ¸¯ÇÑ ´ÙÀ½ frmAddin Á¦°Å ¸¦ Ŭ¸¯ÇϽʽÿÀ.
  4. ÇÁ·ÎÁ§Æ® Ž»ö±â¿¡¼­ ¿¬°á µðÀÚÀ̳ʸ¦ µÎ ¹ø Ŭ¸¯ÇϽʽÿÀ. ÀÀ¿ë ÇÁ·Î±×·¥¿¡ ´ëÇÑ Microsoft Excel À» ¼±ÅÃÇÏ°í ½ÃÀÛÃÊ±â ·Îµå µ¿ÀÛ ¼±ÅÃÇϽʽÿÀ.
  5. º¸±â ¸Þ´º¿¡¼­ ÄÚµå ¸¦ Ŭ¸¯ÇÏ¿© ¹× Ãß°¡ - ÇÔ²² ´ÙÀ½ Äڵ带 ¹Ù²ß´Ï´Ù:
    Option Explicit
    
    Dim oExcel As Object
    Dim WithEvents oButton As Office.CommandBarButton
    
    Private Sub AddinInstance_OnConnection(ByVal Application As Object, _
     ByVal ConnectMode As AddInDesignerObjects.ext_ConnectMode, _
     ByVal AddInInst As Object, custom() As Variant)
    
      Dim oPic As stdole.IPictureDisp
      Dim oMask As stdole.IPictureDisp
    
      ' Load the picture and mask.
      Set oPic = LoadPicture(App.Path & "\circle.bmp")
      Set oMask = LoadPicture(App.Path & "\mask.bmp")
    
      ' Save an instance of our application.
      Set oExcel = Application
      ' Create a new button on the standard CommandBar.
      Set oButton = oExcel.CommandBars("Standard").Controls.Add(msoControlButton)
      With oButton
        ' Set a tag for the button.
        .Tag = "My Button"
        ' Set the event to fire when the button is pressed.
        .OnAction = "!<" & AddInInst.ProgId & ">"
        ' Set the picture property -- if you are using the Mask property, this
        ' property must be set before you set the Mask property.
        .Picture = oPic
        ' Set the Mask property.
        .Mask = oMask
        ' Show the button.
        .Visible = True
      End With
    End Sub
    
    Private Sub AddinInstance_OnDisconnection(ByVal RemoveMode As _
       AddInDesignerObjects.ext_DisconnectMode, custom() As Variant)
    
       ' Delete the button.
       oButton.Delete
       ' Release references.
       Set oButton = Nothing
       Set oExcel = Nothing
     End Sub
    
    Private Sub oButton_Click(ByVal Ctrl As Office.CommandBarButton, _
      CancelDefault As Boolean)
      ' Our button was pressed.
      MsgBox "The button was pressed!"
    End Sub
    					
  6. ÇÁ·ÎÁ§Æ®¸¦ ÀúÀåÇϰí Ãß°¡ ±â´ÉÀÇ ºñÆ®¸ÊÀÌ ÀúÀåµÈ Æú´õ¿¡ ºôµåÇϽʽÿÀ.
  7. ExcelÀ» ½ÃÀÛÇϽʽÿÀ. ³ë¶õ»ö ¿ø ÀÖ´Â »õ ÄÁÆ®·ÑÀÌ Ç¥ÁØ CommandBar µû¶ó ³ªÅ¸³³´Ï´Ù. ¿µ¿ª ÁÖÀ§¿¡ ³ë¶õ»ö ¿ø Åõ¸íÇÕ´Ï´Ù À¯ÀÇÇϽʽÿÀ.

Ãß°¡ Á¤º¸

¾Õ¿¡¼­ ¼³¸íÇÑ °Íó·³ IPictureDisp ÀÎÅÍÆäÀ̽º ÇÁ·Î¼¼½º °æ°è¿¡ °ÉÃÄ ¹è¿­µÈ ¼ö ¾ø½À´Ï´Ù. ´ÙÀ½ ¿À·ù ±×¸² ¹× ¸¶½ºÅ© ¼Ó¼ºÀ» out-of-process °á°ú ¼³Á¤ÇÏ·Á°í ½ÃµµÇÕ´Ï´Ù.
·±Å¸ÀÓ ¿À·ù '-2147418113(8000ffff) ':
'_CommandBarButton' °³Ã¼ÀÇ ' ±×¸²' ¸Þ¼­µå°¡ ½ÇÆÐÇß½À´Ï´Ù.
µû¶ó¼­ ¸ðµç out-of-process ÀÚµ¿È­ Ŭ¶óÀÌ¾ðÆ®¿¡¼­ ¶Ç´Â Visual Basic IDE µð¹ö±× ¸ðµå¿¡¼­ ½ÇÇà ÁßÀÎ ÇÁ·Î¼¼½º ±¸¼º ¿ä¼Ò¿¡¼­ CommandBarButton¿¡ ´ëÇØ ÀÌ·¯ÇÑ ¼Ó¼ºÀ» ¼³Á¤ÇÒ ¼ö ¾ø½À´Ï´Ù. Ãß°¡-Visual Basic IDE¿¡¼­ ÀÌ ¹®¼­¿¡ ¼³¸íµÇ¾î ÀÖ´Â ¿¹Á¦ ½ÇÇàÇÏ´Â °æ¿ì ÀÌ ¿À·ù¸¦ ¸Þ½ÃÁö°¡ ³ªÅ¸³³´Ï´Ù. µð¹ö±ëÇÏ´Â µ¿¾È ¿À·ù°¡ ¹ß»ýÇÏÁö ¾Êµµ·Ï ÇÏ·Á¸é ±×¸² ¹× ¸¶½ºÅ© ¼Ó¼ºÀ» ¼³Á¤Çϰųª °°Àº Á¶°ÇºÎ ÄÄÆÄÀÏÀ» »ç¿ëÇÏ¿© ÁÙÀ» ÁÖ¼®À¸·Î ÀÖ´Â # If... Then... #Else Áö½Ã¹®À».

ÂüÁ¶

ÀÚ¼¼ÇÑ ³»¿ëÀº Microsoft ±â¼ú ÀÚ·áÀÇ ´ÙÀ½ ¹®¼­¸¦ ÂüÁ¶ÇϽʽÿÀ.
238228¾ø´Â Office 2000 COM Ãß°¡ ±â´É Visual BasicÀÇ ºôµå ¹æ¹ý
230689¿¹Á¦: Comaddin.exe Office 2000 COM Ãß°¡ Visual C++¿¡¼­ ±â·ÏµÈ ±â´É
150034PRB: ÇÁ·Î¼¼½º °æ°è °£ LPPICTUREDISP ¼º°ø ¼ö ¾ø´Ù
ÀÚ¼¼ÇÑ ³»¿ëÀº ´ÙÀ½ Microsoft À¥ »çÀÌÆ®¸¦ ÂüÁ¶ÇϽʽÿÀ.
http://support.microsoft.com/ofd

¼Ó¼º

±â¼ú ÀÚ·á: 286460 - ¸¶Áö¸· °ËÅä: 2007³â 1¿ù 29ÀÏ ¿ù¿äÀÏ - ¼öÁ¤: 4.6
º» ¹®¼­ÀÇ Á¤º¸´Â ´ÙÀ½ÀÇ Á¦Ç°¿¡ Àû¿ëµË´Ï´Ù.
  • Microsoft Visual Basic Enterprise Edition for Windows 6.0
  • Microsoft Visual Basic 6.0 Professional Edition
  • Microsoft Office Access 2003
  • Microsoft Access 2002 Standard Edition
  • Microsoft Office Excel 2003
  • Microsoft Excel 2002 Standard Edition
  • Microsoft Office Word 2003
  • Microsoft Word 2002 Standard Edition
  • Microsoft Office FrontPage 2003
  • Microsoft FrontPage 2002 Standard Edition
  • Microsoft Office Outlook 2003
  • Microsoft Outlook 2002 Standard Edition
  • Microsoft Office PowerPoint 2003
  • Microsoft PowerPoint 2002 Standard Edition
Ű¿öµå:?
kbmt kbautomation kbhowto KB286460 KbMtko
±â°è ¹ø¿ªµÈ ¹®¼­
Áß¿ä: º» ¹®¼­´Â Àü¹® ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ °ÍÀÌ ¾Æ´Ï¶ó Microsoft ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î·Î ¹ø¿ªÇÑ °ÍÀÔ´Ï´Ù. Microsoft´Â ¹ø¿ª°¡°¡ ¹ø¿ªÇÑ ¹®¼­ ¹× ±â°è ¹ø¿ªµÈ ¹®¼­¸¦ ¸ðµÎ Á¦°øÇϹǷΠMicrosoft ±â¼ú ÀÚ·á¿¡ ÀÖ´Â ¸ðµç ¹®¼­¸¦ Çѱ۷ΠÁ¢ÇÒ ¼ö ÀÖ½À´Ï´Ù. ±×·¯³ª ±â°è ¹ø¿ª ¹®¼­°¡ Ç×»ó ¿Ïº®ÇÑ °ÍÀº ¾Æ´Õ´Ï´Ù. µû¶ó¼­ ±â°è ¹ø¿ª ¹®¼­¿¡´Â ¸¶Ä¡ ¿Ü±¹ÀÎÀÌ Çѱ¹¾î·Î ¸»ÇÒ ¶§ ½Ç¼ö¸¦ ÇÏ´Â °Íó·³ ¾îÈÖ, ±¸¹® ¶Ç´Â ¹®¹ý¿¡ ¿À·ù°¡ ÀÖÀ» ¼ö ÀÖ½À´Ï´Ù. Microsoft´Â ³»¿ë»óÀÇ ¿À¿ª ¶Ç´Â Microsoft °í°´ÀÌ ÀÌ·¯ÇÑ ¿À¿ªÀ» »ç¿ëÇÔÀ¸·Î½á ¹ß»ýÇÏ´Â ºÎ Á¤È®¼º, ¿À·ù ¶Ç´Â ¼ÕÇØ¿¡ ´ëÇØ Ã¥ÀÓÀ» ÁöÁö ¾Ê½À´Ï´Ù. Microsoft´Â ÀÌ·¯ÇÑ ¹®Á¦¸¦ ÇØ°áÇϱâ À§ÇØ ±â°è ¹ø¿ª ¼ÒÇÁÆ®¿þ¾î¸¦ ÀÚÁÖ ¾÷µ¥ÀÌÆ®Çϰí ÀÖ½À´Ï´Ù.

Çǵå¹é º¸³»±â