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

[­ì³Ð] «Ý½×¾Â»E·|µoªí¤å³¹VBA Module to Hide Method

[­ì³Ð] «Ý½×¾Â»E·|µoªí¤å³¹VBA Module to Hide Method

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-7-8 11:56 ½s¿è

ªñ¦~ªü¦N¤â¤¤¤wµo®i¥X¡AVBA¥¼¤½¶}§Þ³N [VBA Module to Hide Method]¡A¨Ã¥B¤w¥Ó½Ðµo©ú±M§Q¡A¹ï©óVBAµ{¦¡¨¾Å@¤W¥i»¡¬O¤@­Ó·sªº¨½µ{¸O

¦¹§Þ³N¥i¥HÁôÂÃVBA±M®×¤¤ªº­Ó§O¼Ò²Õ¡AÅý¤H¬Ý¤£¨ìVBA±M®×¤¤¬Y´X­Ó¸g¹L³B²z¹Lªº¼Ò²Õ»P¨ä¤¤ªºµ{¦¡½X¡C
ÂǥѦ¹¤èªk¡AEXCEL/WORD 97ª©¥H«á¦UºØÀɮ׮榡¡A¥u­n¤º§tVBA¼Ò²Õ¬Ò¥i®M¥Î¡AÅý¨Ï¥ÎªÌ¥i¥H§Ö³t¥B¦w¥þªºÁôÂÃVBA±M®×¤ºªº­Ó§O/¦h­Ó¼Ò²Õ¡A­«­nªº¬O¸g¹LÁôÂüҲդº¤§µ{¦¡½X¤´¥i¥H¥¿±`¹B¦æ¨Ï¥Î¡A¹F¨ì¤@¤è­±¥i¥HÅý¨Ï¥ÎªÌ¥¿±`¨Ï¥ÎÀɮסA¥t¤@¤è­±¤S¥i¥H¨¾¤î­«­n¤å¥ó¤ºªºVBAµ{¦¡½X¤£³Q¦³¤ß¤H«DªkÅѨú¤Î¿sµø¡C

VBA«OÅ@«O±K»P¯}¸Ñ¡A¬OVBA¶i¶¥¨Ï¥ÎªÌ©Ò¥²¶·¾Ç²ßªº§Þ¥©¡A¦pªG§A¼ô±xVBA«OÅ@
¬Û«H·|ª¾¹D¦¹§Þ³N¤@©ñ¥X¥h.«Ü§Ö±N¦¨¬°VBA¨¾Å@¥D¬y
----------------------------------------------------------------------------------------------------------------------------

¥Ø«e¦¹§Þ³N¥@¬É¤Wºô¸ô¤W¥çµL¥ô¦ó¸ê®Æ¡A¦pMSDN¦^´_¦p¤U

¥xÆWmsdn ½Ð±ÐOFFICE VBA¤¤ªº¼Ò²ÕModule¥i§_ÁôÂð_¨Ó?
http://social.msdn.microsoft.com ... d-9ceb-a838ccd45fa9

¬ü°êmsdn  How to hide Excel VBA module?
http://social.msdn.microsoft.com ... 8-b452-943dc20c2354

VBA Module to Hide Method¡AÀ³¥Î¦bEXCEL¤w§@¦¨¼W¯q¶°¦p¤U¹Ï


¤w¼Ò²ÕÁôÂÃ.xls / .xlsm...µ¥¥¨¶°®æ¦¡Àɮצ¨«~¦p¤U:
[­ì³Ð] ¸T¤î¨Ï¥ÎªÌ¨Ï¥ÎEXCEL VBE½s¿è¾¹
[­ì³Ð] ¤£¯}¸Ñvba±M®×Âê©w状ºA¤U¶×¤J·s¼Ò²Õ(¤º§t:¶×¤J¼Ò²Õ»Pµ{§Ç­ì²z§@ªk)
[­ì³Ð] ¦Û°Ê¦w¸Ë(&¨Ï¥Î»¡©ú)LOCKTOOLAL¼W¯q¶°
²©öª©ªº¥é VBA±M®×¥[¸ÑÂê¾¹¼W¯q¶°
[­ì³Ð] LOCKTOOL¼W¯q¶°
[­ì³Ð] ¨Ï¥ÎExcel»s§@µµ·L¤æ¼Æ±Æ½Lµ{¦¡

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2012-6-8 22:51 ½s¿è

¦¨«~¤w¸g©ñ¤W¨Ó¤F
¹ï¯}¸Ñ¦³¿³½ìªº¹Ù¦ñ¡A¥i¥H¤U¸ü¨Óª±ª±
¯}¸Ñ¤£Ãø¡AÁ`¤§¬OºØ¤£¿ùªº¤èªk
¥tÅP¤@±ø¹D¸ô¡A¤£¬O¨«DLL¸ô½u
DLL¥²¶·­n¸ü¤J¦w¸Ë¡A³o­Ó¤èªk¤£¥Î¡A¸û¤è«K

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2013-1-15 21:54 ½s¿è

±À¼s¤å³¹
³o¤@©« ³Ìªñ¦b¤j³°³Ì¤jEXCELºô¯¸ EH «Ü¬õ¤õ ¤]§n¨ì½±¼
ªü¦N¬D¾ÔµØ»y°Ï³Ì¤jªº´X­ÓEXCELºô¯¸.¨ì²{¦b¹L¤F¥b¦~¤~¦³­Óµ²ªG
§â³sµ²©ñ¤W¨Ó¤j®a¥i¥H¬Ý¨ì¡A¸Ì­±©µ¦ù¤F¨â­Ó¤è¦Vªº§Þ³N¡A§Æ±æ¹ï¤j®a¦³À°§U


1.细数Excel¥v¤W¬D战§»¦w¥þ级别ªº¨Ò¤l

2.*******隐ÂÃvba¤¤ªº¼Ò块¡A°_¨ì«O护vba¥N码ªº§@¥Î¡F¥H¤Î¥ÎVBA来´£¨úVBA Streamªººt¥Ü

3.§ó·s¡GVBA Dumper v0.12¡A ´£¨úoffice¤å档¤¤ªºVBA¥N码¡A监¬d§»¯f¬r(ºt¥Üª©)

4.[­ì创] ¦A¦¸·qÁܦU¦ì°ª¤â¨Ó¯}¸Ñ³o­ÓÀÉ®×[VBA¼Ò块隐ÂûP¸Ñ°£]

¥æ¬y¡G¦p¦ó«Ê装©M«O护Excel¤å¥ó¨½­±ªº¤½¦¡¤ÎVBA¥N码¡A¨¾¤î³Q§Û袭©M«D±Â权¥~¬y

VBA¼Ò²ÕÁôÂÃ.jpg

¥i¬Ý¨ì¤W­z¹Ï¤ù¡A¦¹©«¼Ò¶ôÁôÂÃ/¼Ò¶ô«D±`ÁôÂÃ/¼Ò¶ôÂà´«¤£¥i§R°£ µ¥¦hºØ§Þ³N¡A¦³¬Û应¤u¨ã---------¥B这Ïú«O护¬O¥i°fªº¡A¾A¦Xªø´Á½s¿èµ{¦¡»P«OÅ@¨Ï¥Î¡A¦¹§Þ³N¥i¥H­ìÀɧå¶q§@ÀɮפºN­Ó¼Ò²ÕÁôÂä]¥i§å¶qN­Ó¼Ò²Õ¸Ñ°£ÁôÂáA«D±`¤è«K¡A¦¹§Þ¥©ªº¯S点¥i¥HÎ`¦X [±M®×¤£¥i检视]+[VBA¼Ò²Õ隐ÂÃ]¡A§Y¨Ï[±M®×±K码]©Î [±M®×¤£¥i检视]³Q¯}¸Ñ¡A[VBA¼Ò²Õ隐ÂÃ]¼Ò²Õ¤´§e现隐ÂÃ状态¡A¦p¦³10个¼Ò²Õ¡A§Ú们¥i¥H§å¶q隐Âè䤤ªº8个¼Ò²Õ¡A¸Ñ°£®É¤]¥i§å¶q¸Ñ°£隐Âè䤤ªº8个¼Ò²Õ©Î6­Ó¼Ò²Õ¡A¤£µ¥µø»Ý¨D¿ï¾Ü¡C

TOP

¤£错¡A¦n¤èªk
ªÌ¦Û

TOP

¦^´_ 4# excelfans
officefanªº
Wangminbaiª©¥D¦n¡AÁÂÁ¡A¦³ªÅ¦h¨Ó³o¬Ý¬Ý

TOP

ªü¦N¤j§A¦n¡A³Ìªñ­è¦n¦³vba±M®×¼Ò²Õ»Ý«OÅ@ªº»Ý¨D¡A¸gºô¸ô·j´M«á§ä¨ì³o¡A¤£ª¾­n¦p¦ó¤~¯à¨Ï¥Î§Aªº¤èªk¨Ó«OÅ@§Úªº±M®×©O?

TOP

终¤_§ä¨ì¤j¦W¹©¹©ªº¡§ªü¦N¡¨¤j师¡I½ 墙  ¤£ ©ö °Ú¡I

TOP

        ÀR«ä¦Û¦b : «H¤ß¡B¼Ý¤O¡B«i®ð¤TªÌ¨ã³Æ¡A«h¤Ñ¤U¨S¦³°µ¤£¦¨ªº¨Æ¡C
ªð¦^¦Cªí ¤W¤@¥DÃD