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

[µo°Ý] ¦p¦ó¸õ¹L¦¹¸ß°Ýµøµ¡?

[µo°Ý] ¦p¦ó¸õ¹L¦¹¸ß°Ýµøµ¡?

¦p¦ó¸õ¹L¦¹¸ß°Ýµøµ¡?¿ïY(¬O)
Snap1.jpg
2014-10-24 15:25

¦^´_ 1# t8899
¸Õ¸Õ¬Ý
  1. Application.DisplayAlerts = False
  2.     '¹w´Á·|¦³¸ß°Ýµøµ¡ ªºµ{¦¡½X...
  3.     '¹w´Á·|¦³¸ß°Ýµøµ¡ ªºµ{¦¡½X...
  4. Application.DisplayAlerts = True
½Æ»s¥N½X
·P®¦ªº¤ß......(¦b³Â»¶®a±Ú°Q½×°Ï.¥Î¤ß¾Ç²ß·|¦³¶i¨Bªº)
¦ý¸ê·½µL­­,«á´©¦³­­,  ¤@¤Ñ1¤¸ªºÃÙ§U,¤H¤H¦³¯à¤O.

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-10-24 18:08 ½s¿è
¦^´_  t8899
¸Õ¸Õ¬Ý
GBKEE µoªí©ó 2014-10-24 16:28


¸Ì­±ªº¿ï¶µ°±¯d¦b No §Ú­n Yes ??
§Ú¥uª¾¬O¬Y¤u§@ªí±Ò°Ê¡A­n©ñ¨º¸Ì?

TOP

À³¸Ó¬O©ñ¦b  ThisWorkbook ¸Ì­±ªº

Private Sub Workbook_Open()

End Sub

TOP

À³¸Ó¬O©ñ¦b  ThisWorkbook ¸Ì­±ªº

Private Sub Workbook_Open()

End Sub
bobomi µoªí©ó 2014-10-24 19:36

³o¬O¬Y¤u§@ªí ±Ò°ÊActiveX±±¨î¶µªº¸ß°Ý
¸Õªºµ²ªGÁÙ¬O·|¥X²{

TOP

¥»©«³Ì«á¥Ñ t8899 ©ó 2014-10-26 22:27 ½s¿è

§ä¤F¦n¤[¤~¦A¹ï©¤½×ôΧä¨ì
¦pªG¶}ªº¤£¬O¦Û¤vªºªºexcel ÀɮסAÁÙ¬OÁÙ­ì¦^¨Ó¸û§´(±Ndword:00000001 §ï¬° dword:00000000 )

Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\VBA\Security]
"LoadControlsInForms"=dword:00000001


Windows Registry Editor Version 5.00

[HKEY_CURRENT_USER\Software\Microsoft\Office\Common\Security]
"UFIControls"=dword:00000001

TOP

¦^´_ 6# t8899


    ¦pªG­n¤@³Ò¥Ã¶h
ª½±µ¦b «H¥ô¤¤¤ß > °T®§¦C > ¥Ã»·¤£­nÅã¥Ü¤w«ÊÂꤺ®eªº¬ÛÃö¸ê°T   §â®Ø®Ø¥´¤Ä..
¦ý   ¦MÀI©Ê»á°ª  ¤×¨ä¬O ¨Ó¸ô¤£¦WªºÀÉ®×

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_  t8899


    ¦pªG­n¤@³Ò¥Ã¶h
ª½±µ¦b «H¥ô¤¤¤ß > °T®§¦C > ¥Ã»·¤£­nÅã¥Ü¤w«ÊÂꤺ®eªº¬ÛÃö¸ê°T   ...
mark15jill µoªí©ó 2014-10-31 17:24


§Úªº¬OEXCEL 2003 µL«H¥ô¤¤¤ß

TOP

¦^´_ 8# t8899


   
¤u¨ã > ¿ï¶µ > ¦w¥þ©Ê > ¥¨¶°¦w¥þ©Ê > ¦w¥þ¼h¯Å ¥i¥H½Õ¾ã...

  ¦h°µ¦h·Q¦h¾Ç²ß¡A¤Ö¬Ý¤Ö¿ù¤Ö°g³~

  ¦h°µ=¦h¦h½m²ß¡A¦h¦h½s¼g¡C
  ¦h·Q=·Q·Q¬°¤°»ò¤H®aµ{¦¡­n¨º¼Ë¼g¡A¦pªG´«¦¨¦Û¤v¡A¤S·|«ç¼g¡C
  ¦h¾Ç²ß=¾Ç²ß¤H®aªºµo°Ý¨Ã¸Ñµª¡A¾Ç²ß¤H®aªº¼gªk

  ¤Ö¬Ý=¥u¬Ý¤£°µ¤]ªPµM

TOP

¦^´_  t8899


   
¤u¨ã > ¿ï¶µ > ¦w¥þ©Ê > ¥¨¶°¦w¥þ©Ê > ¦w¥þ¼h¯Å ¥i¥H½Õ¾ã...
mark15jill µoªí©ó 2014-10-31 19:15

§Ú¸Õ¹L½Õ³Ì§C¤]·|¥X²{ĵ§i

TOP

        ÀR«ä¦Û¦b : «Ý¤H°h¤@¨B¡A·R¤H¼e¤@¤o¡A´N·|¬¡±o«Ü§Ö¼Ö¡C
ªð¦^¦Cªí ¤W¤@¥DÃD