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

[­ì³Ð] ¸T¤î¨Ï¥ÎªÌ¨Ï¥ÎEXCEL VBE½s¿è¾¹

°ÝÃD¦P6#©«¡A¦Ü¤µ°ÝÃD¤´µLªk¸Ñ¨M¡C
Lin

TOP

°ÝÃD¤w¸Ñ¨M¦hÁ¡C
Lin

TOP

«Ü©_©Ç¡A§Ú¿ì¤½«Ç¹q¸£(XP+office 2007)¥i¥H°õ¦æWorkbookVBELOCK ¡A¦ý®a¤¤¹q¸£(Win7+office 2007)·í°õ¦æ¨ì.OnKey "%{F11}", "ShowErr"´N¥d¦í¡A½Ð¦U¤è°ª¤â«ü¥Ü¡C
Lin

TOP

¤µ¤Ñ§Ú¿ì¤½«Ç¹q¸£(XP+office 2007)·í°õ¦æ¨ì.OnKey "%{F11}", "ShowErr"´N¥d¦í¡A¬O§_¦³­n¤@¨Ç¯S§O³]©w¡C
Lin

TOP

1.§Ú®a¤¤¹q¸£(Win7+office 2007)¶}±ÒA19ÀɮסA¿é¤J±K½X«á¥X²{¹ï¸Ü

2.¦b¿é¤J²Ä2²Õ±K½X«á¡Aexcelµe­±¤£¨£¡A¦A­«¶}±ÒA19ÀÉ®×¥X²{

3.«ö¨ú®ø«á¶}±ÒA19ÀɮסA¨ÃµL"¸T¤î¨Ï¥ÎªÌ¨Ï¥ÎEXCEL VBE½s¿è¾¹"
ªþ¥ó: ±z»Ý­nµn¿ý¤~¥i¥H¤U¸ü©Î¬d¬Ýªþ¥ó¡C¨S¦³±b¸¹¡Hµù¥U
Lin

TOP

§Ú¥ÎVBA±M®×²©ö¥[¸ÑÂê¾¹¸Ñ¶}«OÅ@«á¡A³v¨B°õ¦æWorkbookVBELOCK¨ì.OnKey "%{F11}", "ShowErr"´N¥d¦í¡A­Y³v¨B°õ¦æ Function VBE_MW¨ìFor Each I In ThisWorkbook.VBProject.VBE.CommandBars´N¥d¦í¡C
Lin

TOP

microsoft visual basic for applications extensibility 5.3¤w¶}±Ò¡C
Lin

TOP

ªü¦N¥S
1.¥¨¶°¦w¥þ©Ê«H¥ô¿ï¶µ¤Ä¿ï«á¤@¼Ë
2.¤£½×²Ä1©Î2²Õ±K½X¸ÕµÛ³£¤£­n¿é¤J±K½X¡A¤@¼ËµLªk¶}±Ò
3.§Ú®a¤¤¹q¸£(Win7+office 2007)¶}±ÒA19ÀɮסANum Lock Áä on¡A§YµLªk¨Ï¥Î¼Æ¦rÁä¡C
Lin

TOP

ªü¦N¥S
      «Ü³øºp¡A§Ú¥´¦rºC¤S±`¿ù¡A©Ò¥H¦³®Éªí¹F`¤£¬O«Ü²z·Q¡A¹ï©ó¥»¥DÃD§Ú¬O¦³¨â­ÓºÃ°Ý
1.¬°¦ó¦b¤£¦P¹q¸£¡A¦³ªº¥i¥H¶¶§Q°õ¦æ"¸T¤î¨Ï¥ÎªÌ¨Ï¥ÎEXCEL VBE½s¿è¾¹"¡A¦³ªº¤£¦æ¡A16#§Y¬O¹Lµ{¡C¬O§_"¸T¤î¨Ï¥ÎªÌ¨Ï¥ÎEXCEL VBE½s¿è¾¹"¦³µwÅé©Î³nÅé­­¨î¡C
2.¬°¦ó¶}±ÒA19ÀÉ®×(¨S¦³§ó§ïµ{¦¡)¡A·|³y¦¨¼Æ¦rÁäµLªk¿é¤J¡A¬O§_µ{¦¡¤¤·|¦³¤zÂZ¹q¸£³]©w¡C
Lin

TOP

        ÀR«ä¦Û¦b : ¡i°µ¤Hªº¶}©l¡j¨C¤@¤Ñ³£¬O¬G¤Hªº¶}©l¡A¨C¤@­Ó®É¨è³£¬O¦Û¤vªºÄµ±§¡C
ªð¦^¦Cªí ¤W¤@¥DÃD