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

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

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

ÁʶR¥DÃD ¤wÁʶR¤H¼Æ:20  °O¿ý ¥»¥DÃD»Ý¦V§@ªÌ¤ä¥I 5 ª÷¿ú ¤~¯àÂsÄý

¥»©«³Ì«á¥Ñ GBKEE ©ó 2010-5-8 14:46 ½s¿è

¦^´_ 1# HUNGCHILIN
¤£ª¾¹D§Aªº±K½X ¬Ý¤£¨ì§Aªº¤º®e ÁöµMµLªk¶i¤J EXCEL VBE½s¿è¾¹ ¥i¬O§AÁÙ¯d¤F¿ý»s·s¥¨¶°ªº«ü¥O ³o¹Dªù
§Ú§Q¥Î¥¨¶°«ü¥O->½s¿è ¶i¤JVBE½s¿è¾¹ ¼g¤F¥H¤Uµ{¦¡ ¥i¥H¥¿±`¶i¤JVBE½s¿è¾¹ ¤]«ì´_VBE½s¿è¾¹ªº¥\¯àªí
Sub Ex()
    Dim E As CommandBar
    On Error Resume Next
    For Each E In Application.VBE.CommandBars
        E.Reset
        E.Enabled = True
        E.Visible = True
    Next
    For Each E In Application.CommandBars
        E.Reset
    Next
End Sub

TOP

¥»©«³Ì«á¥Ñ luhpro ©ó 2010-5-9 09:43 ½s¿è

GBKEE »¡¨ì :
> ¤£ª¾¹D§Aªº±K½X ¬Ý¤£¨ì§Aªº¤º®e ÁöµMµLªk¶i¤J EXCEL VBE½s¿è¾¹ ¥i¬O§AÁÙ¯d¤F¿ý»s·s¥¨¶° ...
(¾l®¤§R)

¦b°õ¦æ¤Fªü¦Nªº A19.xls Àɮ׫áµo²{ :
¤§«á¤£½×°õ¦æ­þ­Ó Excel ÀÉ®×,
¥u­n¤º§t¥¨¶°³£·| "¦Û°Ê¶}±Ò" ªü¦Nªº A19.xls ¤¤ªº¥¨¶°µ{¦¡,
¾É­P§Ú¦Û¤v¦b§O­ÓExcelÀɮפº³]­pªºµ{¦¡¤Ï¦Ó¥u¯à°õ¦æ¦ÓµLªk½s¿è.

³o½g­è¦n±Ï¤F§Úªº¿U¬Ü¤§«æ,
¤]¦n¦bªü¦N¤§«e¨Ã¨S¦³Âê±¼¿ý»s·s¥¨¶°ªº¥\¯à.^^

TOP

HUNGCHILIN¥S ¤p§Ì¥Î¤F´X­Ó«D¥¿²Îªº¤è¦¡¸Ñ¶}¤F!
1.­º¥ý¥ý¥Ñ±zªº±M®×±K½XµÛ¤â! ©Ò¥H­«·s½s¼g¯}¸Ñ(16¶i¦ì¤è¦¡...)
2.¥ÎVBS CreateObject¤è¦¡ ¥ý¶}±Ò! ©Ò¥H¥i¥HÁ×¹LAUTO_OPEN...

¥H¤U¬OHUNGCHILIN¥Sªºµ{¦¡
Option Explicit
Public Const APPNAME As String = "§@ªÌ:Hung-Chi Lin"
Private Sub VBProjectProtection()
On Error Resume Next
Application.ScreenUpdating = False

HUNGCHILIN¥S ªº¤è¦¡ªGµM°ª©Û ¯à¥Î¦p¦¹ªº¤è¦¡¥[±K...
¹ï¤F HUNGCHILIN¥S ªºµ{¦¡³£¨S¦³ÁY±Æ ¤p§Ì¬Ý±o¦n¨¯­W³á>"< ¨þ¨þ¨þ~

TOP

^^¨º®É·Q¨SÁY±Æ ¥i¥H¸`¬ÙÀɮפj¤p ´N³£§âªÅ®æ§R¤F

TOP

¦b°õ¦æ¤Fªü¦Nªº A19.xls Àɮ׫áµo²{ :
¤§«á¤£½×°õ¦æ­þ­Ó Excel ÀÉ®×,
¥u­n¤º§t¥¨¶°³£·| "¦Û°Ê¶}±Ò" ªü¦Nªº A19.xls ¤¤ªº¥¨¶°µ{¦¡,
¾É­P§Ú¦Û¤v¦b§O­ÓExcelÀɮפº³]­pªºµ{¦¡¤Ï¦Ó¥u¯à°õ¦æ¦ÓµLªk½s¿è.

§ÚÀ³¦p¦ó­×¥¿¤~¯à¾Ö¦³­ì¨Ó¤§½s¿è¥\¯à??????/

TOP

¦^´_ 6# jim
§A¥i¦A¸Ô¬Ý¤@¦¸³o½g¤¤ªº¦^´_¤å

TOP

¥»©«³Ì«á¥Ñ HUNGCHILIN ©ó 2010-5-17 20:37 ½s¿è

³o­ÓÀɮקڻs§@¤F¼Æ¦~¦Ü¤Ö¤­¤»¦~¥H¤W
§Ú¦Û¤v³£§Ö§Ñ°O¸Ì­±§Ú¼g¤F¤°»ò
¥u¤j·§ª¾¹D¬O¤°»òÃþ«¬ªºÀÉ
§ì¤F´N©ñ¤W¨Ó·í¦¹Ãþ«¬ªº½d¨Ò
----------------------------------------------------
­è¦Û¤v¤U¸ü¥´¶}¨Ó¬Ý¬Ý--¤£¶}¤£ª¾¹D ¶}¤FÀ~¤@¸õ
³s§Ú¦Û¤v³£§Ñ°O§Ú¸Ì­±¦³¥[¤J"¿é¤J±K½X"¤~¯à¨Ï¥Î³o¦^¨Æ...·w
^^""


Ãö©ó¸Ñ°£¦¹Àɪºµ{¦¡ªº¤èªk
1.½Ð¦b¦¹ºô­¶¤W«ö CTRL+A
2.¦b¿ï¾Üª¬ºA¤U¨ìºô­¶³Ì¤W¤è"1#©«³B"Æ[¬Ý´N¥i¥HÁA¸Ñ¸Ñ°£¤èªk

TOP

GBKEE Thanks
  °ÝÃD¤w¸Ñ¨M
ªü¦N¥ç¦hÁÂ

TOP

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

TOP

        ÀR«ä¦Û¦b : µêªÅ¦³ºÉ¡D§ÚÄ@µL½a¡AµoÄ@®e©ö¦æÄ@Ãø¡C
ªð¦^¦Cªí ¤W¤@¥DÃD