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

Excel¤¤¡A¥kÁä·s¼W¶µ¥Ø

Excel¤¤¡A¥kÁä·s¼W¶µ¥Ø

½Ð°Ý¤@¤U¡A¨Ò¦p¦bwindowsÀÉ®×Á`ºÞ¤º¡A§Ú­Ì¥i¥H³z¹L¬Y¨Ç¤èªk¡A¦b«ö¤U¥kÁä©Ò±Ò°Êªº¿ï³æ¤¤¡A¥[¤J§Ú­Ì·Q­nªº¶µ¥Ø¡C
¨º¦bexcel¤¤¦³¨S¦³Ãþ¦üªº¥\¯à¡A¨Ò¦pÀH«K¤@­ÓÀx¦s®æ¤W«ö¤U¥kÁä©Ò±Ò°Êªº¿ï³æ¤¤¡A¥[¤J¤@­Ó¶µ¥Ø¡A¦Ó³o­Ó¶µ¥Ø¥i¥H¥´¶}§Ú¦Û¤v°µªºform©Îcombo¡A¤£ª¾excelªºvba¯à§_¹F¨ì¦¹¥\¯à¡H
½Ð±Ð¦U¦ì«e½ú¡AÁÂÁ¦U¦ì¡I

¨Ò¦p¡G
Sub xx()
With Application.CommandBars("Cell")
    .Reset
    .Controls.Add(Type:=msoControlButton, before:=2).Caption = "¥¨¶°1"
    .Controls("¥¨¶°1").OnAction = "yy"
    End With
End Sub
¦b¥kÁ䪺²Ä¤G¶µ¼W¥[¤@­Ó°õ¦æ¥¨¶°1ªº¶µ¥Ø¡A¸Ó¶µ¥Ø«ü¦V¦W¬°"yy"ªº¥¨¶°
Â÷¶}®É­n²¾°£
Private Sub Workbook_BeforeClose(Cancel As Boolean)
Application.CommandBars("cell").Reset
End Sub

TOP

¦n¼F®`¡I¦^À³¦n§Ö¡I¦¨¥\¤F¡AÁÂÁÂoobird¡I

TOP

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