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

[µo°Ý] VBA½s¿è¾¹¤¤ªº¥\¯àªí»P¤u¨ã¦C¤£¨£¤F!

[µo°Ý] VBA½s¿è¾¹¤¤ªº¥\¯àªí»P¤u¨ã¦C¤£¨£¤F!

VBA½s¿è¾¹¤¤ªº¥\¯àªí»P¤u¨ã¦C¤£¨£¤F!

1541962321913.jpg (27.33 KB)

1541962321913.jpg

¦^´_ 1# henry860608


    Ctrl+R¸Õ¸Õ
¤@¤À§V¤O¡A¤@¤À¦¬Ã¬¡C
µo°ÝÃD«e¥i¥H¥ý·j¯Á¤º¤å¬O§_¦³¬ÛÃö½d¨Ò¡C

TOP

ctrl+R ¥i¥H¥s¥X±M®×µøµ¡¡A¦ýµLªk¥s¥X¥\¯à¦C»P¤u¨ã¦C

1542037002403.jpg (41.55 KB)

1542037002403.jpg

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2018-11-13 01:20 ½s¿è

¦^´_ 3# henry860608


§ÚÃhºÃ§A¥i¯à¤¤¬r¤F!? ¡A
¤£µM¨S¨Æ½Ö·|¥hÃö±¼¨º­Ó
¿é¤J¥H¤Uµ{¦¡½X¡A«öF5°õ¦æ


Sub ¥´¶}VBE¥\¯à¦C()
'«öF5 °õ¦æ(¦]¬°§A³s°õ¦æ«ö¶s³£¨S±o«ö)
Application.VBE.CommandBars("¥\¯àªí¦C").Enabled = True
Application.VBE.CommandBars("¤@¯ë").Enabled = True
Application.VBE.CommandBars("½s¿è").Enabled = True
Application.VBE.CommandBars("°»¿ù").Enabled = True
End Sub
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 3# henry860608


    «öµÛAlt¡A¥ýV¡÷¢â¡÷¢Ñ¡A¤Ä¿ï¥\¯à¦Cªí¡C

°O±o«ö¦^ÂЧڤ~¬Ý±o¨ì§Y®É³qª¾¡C
¤@¤À§V¤O¡A¤@¤À¦¬Ã¬¡C
µo°ÝÃD«e¥i¥H¥ý·j¯Á¤º¤å¬O§_¦³¬ÛÃö½d¨Ò¡C

TOP

¥»©«³Ì«á¥Ñ n7822123 ©ó 2018-11-13 10:54 ½s¿è

¦^´_ 5# faye59


­è­è¸Õ¤F¤@¤U¡A³QÃö±¼ªº¸Ü¡A
¥Î¨ººØ­n³sÄò«öªº§Ö±¶Áä¨S¦³§@¥Î¡A
¤£«H§A¥i¥H¹Á¸Õ¤@¤U

Application.VBE.CommandBars("¥\¯àªí¦C").Enabled = False
Application.VBE.CommandBars("¤@¯ë").Enabled =  False
Application.VBE.CofmmandBars("½s¿è").Enabled =  False
Application.VBE.CommandBars("°»¿ù").Enabled =  False


¦Ó¥B"¥\¯àªí¦C"¡A§Ú¦Û¤v¸Õ¹LµLªk¤â°Ê¨ú®ø
©Ò¥H°õ¦æ¨ì¤£¸Ó°õ¦æªºµ{¦¡½X¡A¬O¤ñ¸û¦³¥i¯à±¡ªp
µ{¦¡¬O¨Ì»Ý¨D¼gªº¡A»Ý¨Dªí¹F¤£²M·¡
©ÎªÌ¨S¦³¤W¶Çªþ¥ó¡A·R²ö¯à§U

TOP

¦^´_ 6# n7822123


    ¦hµ¹¥L¤@­Ó¿ï¾Ü°Ñ¦Ò¸ê°T¡A©Î³\¨Ã«D§Ú­Ì©Ò²q´úªº°ÝÃD¡C
¤@¤À§V¤O¡A¤@¤À¦¬Ã¬¡C
µo°ÝÃD«e¥i¥H¥ý·j¯Á¤º¤å¬O§_¦³¬ÛÃö½d¨Ò¡C

TOP

        ÀR«ä¦Û¦b : ¤Hªº¤ß¦a¬O¤@²¥¥Ð¡A¤g¦a¨S¦³¼½¤U¦nºØ¤l¡A¤]ªø¤£¥X¦nªºªG¹ê¡C -
ªð¦^¦Cªí ¤W¤@¥DÃD