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

«Ì½ª¿ý»s¥¨¶°¶s

«Ì½ª¿ý»s¥¨¶°¶s

¥­¦w
¥\¯à¦C¸Ìªº"¿ý»s·s¥¨¶°"¶s
·Q±N¥¦«Ì½ª
¥N½X­n«ç»ò¤U¡H
µL¤îºÉªº§V¤O¤W¶i

¥­¦w
¥\¯à¦C¸Ìªº"¿ý»s·s¥¨¶°"¶s
·Q±N¥¦«Ì½ª
¥N½X­n«ç»ò¤U¡H
vinejason µoªí©ó 2014-5-29 14:00


¨Ï¥Î¥H¤U¥N½X¥i¥H«Ì½ª¤u¨ã¶s
¦ý¬O­Y¥u«Ì½ª ¿ý»s·s¥¨¶° ¥i¥H°µ±o¨ì¶Ü

Application.CommandBars("Worksheet Menu Bar"). _
  Controls("¤u¨ã(&T)").Enabled = False
µL¤îºÉªº§V¤O¤W¶i

TOP

¦^´_ 2# vinejason
Ãþ¦ü³o¼Ë§a¡A§Ú¥u¦³Excel 2010¥u³Ñ"¥\¯à°Ï"¤F¡A¨S¿ìªk´ú¸Õ¡C
  1.   For Each x In Application.CommandBars("Worksheet Menu Bar").Controls("¤u¨ã(&T)").Controls("¥¨¶°(&M)").Controls
  2.     If InStr(x.Caption, "¿ý»s·s¥¨¶°") Then x.Enabled = False: Exit For
  3.   Next
½Æ»s¥N½X

TOP

¦^´_ 3# stillfish00

ÁÂÁ±zªºÀ°¦£
¯¬±zºÝ¤È¨Î¸`§Ö¼Ö
¥­¦w ³ß¼Ö
µL¤îºÉªº§V¤O¤W¶i

TOP

        ÀR«ä¦Û¦b : ¡i¥Í©R¦b©I§l¶¡¡j¦òªû»¡¡G¡u¥Í©R¦b©I§l¶¡¡C¡v¤HµLªkºÞ¦í¦Û¤vªº¥Í©R¡A§óµLªk¾×¦í¦º´Á¡AÅý¦Û¤v¥Ã¦í¤H¶¡¡C¬JµM¥Í©R¥h¨Ó³o»òµL±`¡A§Ú­Ì§óÀ³¸Ó¦n¦n¦a·R±¤¥¦¡B§Q¥Î¥¦¡B¥R¹ê¥¦¡AÅý³oµL±`¡BÄ_¶Qªº¥Í©R¡A´²µo¥¦¯uµ½¬üªº¥ú½÷¡A¬M·Ó¥X¥Í©R¯u¥¿ªº»ù­È¡C
ªð¦^¦Cªí ¤W¤@¥DÃD