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

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

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

TOP

Alt + F11 ??

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

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-5-2 18:14 ½s¿è

¦^´_ 14# lin

³o­ÓÀɫܤ[¤F¦Ü¤Ö10¦~ ¦n¹³ 2003¦~©ñ¦bOFFICEºë­^­Ñ¼Ö³¡.°Q½×¥Îªº
¦]¬°¨Ï¥Î«áVBA¤£¯à½s¿è.¤£¸Ñ¤£¦æ.¨º®É­Ô¦U¤j½×¾Âªá¤F3¤Ñ¤~¸Ñ¥X¨Ó.ªü¦N³Q©À¤F¦n´X­Ó¤ë^^.¤£¹L«Ü¦nª±

±z¦³§ó§ï¹Lµ{¦¡¶Ü?´Á¶¡¨S¦³¤H´£¥X³oºØ°ÝÃD
WINXP+OFFICE2003:VISTA+OFFICE2007:²{¦b WIN7+OFFICE2010 OK

¥H«e§Ú°O±o¬O¦³§@¤@­Ó³o¼ËªºSUB .¨S¬Æ»ò¥Î³B.«á¨Ó§Ú§R¤F
±z¸ÕµÛ§â¥L¥[¤J.§Ú·QÀ³¸Ó´N¥i¥H¤F

Sub ShowErr()
MSGBOX "¤£¥i¥H¨Ï¥ÎVB½s¿è¾¹"
End Sub

­n¤£µM§â³o¦æ.OnKey "%{F11}", "ShowErr"§R¤F¤]À³¸Ó¤£·|¼vÅT¥\¯à

¦¹©«§Ú 2012-6-8 18:24 ±N¥¦¦C¬°¼Ò²ÕÁôÂ꺩«¤l»P½d¨Ò[­ì³Ð] «Ý½×¾Â»E·|µoªí¤å³¹VBA Module to Hide Method ©Ò¥HªþÀɦ³´«¹Lµ{¦¡¼Ò²Õ¦³§@ÁôÂÃ
­n¬Ý­ì©lµ{¦¡http://www.wretch.cc/blog/HUNGCHILIN/11301541

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

¦^´_ 18# lin


²Ä¤@¼h±K½X¬O±Ò°Ê±K½X
²Ä¤G¼h±K½X¥­®É¤£会¥X现¡A¥u¦³¯}¸ÑVB ±M®×®É¤~·|¥X现

1±z¸ÕµÛ¨ì¥¨¶°¦w¥þ©Ê«H¥ô¿ï¶µ¬ÝvB ¦³¨S¤Ä¿ï¡A­n¤Ä
2±z¸ÕµÛ³£¤£­n¿é¤J±K½XRun ¬Ý¬Ý

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

        ÀR«ä¦Û¦b : ¨Ã«D¦³¿ú¾{¬O§Ö¼Ö¡A°Ý¤ßµL·\¤ß³Ì¦w¡C
ªð¦^¦Cªí ¤W¤@¥DÃD