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

[µo°Ý] §O¥x¶}±ÒVBA«á¡AÂI±±¨î«ö¶s«o¨S¤ÏÀ³(¤w¸gª¦¹L«Ü¦h«Ü¦h¤å...)

[µo°Ý] §O¥x¶}±ÒVBA«á¡AÂI±±¨î«ö¶s«o¨S¤ÏÀ³(¤w¸gª¦¹L«Ü¦h«Ü¦h¤å...)

¤j®a¦n¡A¦]¤p©f¬OVBA¥®¥®¯Z¡A¦n¤£®e©ö¼g§¹¤@­ÓVBA¡A®³¨ì¨ä¥L¦P¨Æ¹q¸£¥Î¡Cµo²{§O¥x¹q¸£ÂI¤u§@ªí1ªºcommand button¡A¥»¨Ó­n¸õ¥X¨ÓªºUserForm«o¨S¥X²{¡A¦Ó¦P¤@­ÓÀɮקڦۤv¸Õ¬O¥¿±`¨S°ÝÃDªº¡C
§Ú¤½¥q²Î¤@¬OWIN7 + OFFICE2010¡A¸Õ¤F¦n´X­Ó¦P¨Æªº¹q¸£¡A¤@«ß¨S¤ÏÀ³¡C
ª¦¹L«Ü¦hÃþ¦ü³oºØ±¡ªpªº¤å¡A«o²@µLÀYºü¡C½Ð¦U¦ì¤j«L©M¤k«L±Ï±Ï§Ú~Àɮ׽аѦҪþ¥ó>"< TEST.rar (102.12 KB)

§Ú¦P®É¶}2¥x¹q¸£´ú¸Õ¡Aµ²ªG¦p¤U¡G

1. ¦bCommandButton¥¢®Äªº¹q¸£¡A²¤¹L¦b¤u§@ªí1ÂICommandButton·|¼u¥XUserFormªº°Ê§@¡Aª½±µ¸Õ¶]«á­±ªºµ{¦¡¡Aµ²ªG³£¦n¦nªº¨S°ÝÃD¡C

2. µM«á¤S¸ÕµÛ°õ¦æ"UserForm¤¤³]­pªºCommandButton"¡Aµ²ªG¤]OK¨S°ÝÃD¡C

3. ¦bCommandButton¥¢®Äªº¹q¸£¡A°õ¦æ¤u§@ªí1ªº3­Óµ{¦¡(¦p¤U¹Ï)³£¥¢±Ñ

¦pªG°õ¦æ³o3­Óµ{¦¡¡A³£·|¥X²{¿ù»~°T®§


4. §Ú¦b§Ú¹q¸£¤¤ÀH«K¶}·sªºEXCEL¡A¼g¤@­Ó
  1. Private Sub CommandButton1_Click()
  2.     UserForm2.Show
  3. End Sub
½Æ»s¥N½X
¦b¨ä¥L¹q¸£¤´Â¨S¤ÏÀ³

½Ð°Ý¦p¦ó¸Ñ¨M?

Private Sub CommandButton1_Click()
VBAProject.UserForm1.Show
End Sub

Ãö³¬©Ò¦³ Office ¬ÛÃöªº³nÅé¡A¶}±ÒÀÉ®×Á`ºÞ¡A¤Á´«¦Ü¸ô®| C:\Users\ [¨Ï¥ÎªÌ¦WºÙ] \AppData\Local\Temp\Excel8.0 ©M C:\Users\ [¨Ï¥ÎªÌ¦WºÙ] \AppData\Local\Temp\VBE¡A±N MSForms.exd §ó¦W©Î§R°£«á¡A­«·s¶}±Ò Excel ¶i¦æ´ú¸Õ©Î·L³nºô§}»¡©úhttps://support.microsoft.com/kb/3025036/zh-tw

TOP

°_¦]©ó§ó·s¤Foffice patch
§Ú¬O°Ñ¦Ò³o¤@½g¸Ñ¨M
http://stackoverflow.com/questions/27411399/microsoft-excel-activex-controls-disabled

TOP

ÁÂÁ¨â¦ìªº¦^ÂСA§Ú¥Î#2ªº¤è¦¡´ú¸Õ¤F4¥x¹q¸£¡A§â¹q¸£§ó·s¨ì³Ì·s«á¡A¦Ühttps://support.microsoft.com/kb/3025036/zh-tw ¤U¸ümicrosoft fix¡A¦³2¥x¦¨¥\¥i¥H¥ÎactiveX±±¨î¶µ¡A¦³2¥x¨ÌµM¨S¤ÏÀ³¡C

­è¤~¦A°Ñ¦Ò#3¤j¤j´£¨Ñªº¤å³¹¡Aµo²{¥¢±Ñªº¹q¸£³£¦³¤@­Ó¦@³qÂI¡C
·í§Ú¶}±Ò¥]¬AActiveXªºExcel«á¡A´ú¸Õµo²{¤£¦¨¥\«á¡CµL½×¦³§_§ó§ïExcel¥ô¦ó¤º®e¡A¥u­n§Ú¦sÀÉ«á­«¶}ÀɮסA³£·|¥X²{¤U¹Ïµe­±¡C


½Ð°Ý¬Oµo¥Í¤°»ò¨Æ©O?

TOP

¦^´_ 3# clietj37

¤j¤j§A¦n¡A­è¤~¤w¸g¬Ý¹L§Aªº´£¨Ñªº¸Ñ¨M¤è¦¡¡C¦]¬°¦³¨Ç¹q¸£¤´µM¤£¦¨¥\¡C©Ò¥H§Ú°Ñ¦Ò¤å³¹¤¤ªºAdditional Step

Additional step:

If the steps above do not resolve your issue, another step that can be tested (see warning below):

On a fully updated machine and after removing the .exd files, open the file in Excel with edit permissions.

Open Visual Basic for Applications > modify the project by adding a comment or edit of some kind to any code module > Debug > Compile VBAProject.

Save and reopen the file. Test for resolution. If resolved, provide this updated project to additional users.

Warning: If this step resolves your issue, be aware that after deploying this updated project to the other users, these users will also need to have the updates applied on their systems and .exd files removed as well.


¬Ý±o¤£¬O«ÜÀ´"modify the project by adding a comment or edit of some kind to any code module > Debug > Compile VBAProject."¬O­n°µ¤°»ò? ¬OÀH«K½s¿èVBA¤¤¥ô¦ó¤º®e¶Ü? Debug ¸ò Compile VBAProject ¨C­Ó¦r³£ª¾¹D·N«ä¡A¦ý¥[°_¨Ó´N¤£ª¾¹D¹ê»Ú­n¶i¦æ¤°»ò°Ê§@...?{:3_60:}

¦ý§ÚÀH«K½s¿è¤@¤U«á­«¶}ÀÉ®×´N¥X²{§Ú¦b#4´y­zªº±¡ªp¡C¨D¤j¯«¸Ñ´b~~

TOP

³o°ÝÃD¶W¥X§Úªº¯à¤O½d³ò¤F¡A¤]³\ª©¤W¦³¨ä¥L¤H¸I¹L¡A¤£¦n·N«ä

TOP

°Ñ¦Ò·L³nºô§}»¡©úhttps://support.microsoft.com/kb/3025036/zh-tw ¬O§_¦¹°ÝÃD

TOP

§Ú¤U¸ü¤F³o­ÓÀɮסAhttp://www.excelclout.com/microsoft-update-breaks-excel-activex-controls-fix/
¦³¨Ç¹q¸£¥i¥H¸Ñ¨M°ÝÃD¡A¦ýÁÙ¬O¦³¦n´X¥x¹q¸£¤£¯à¸Ñ¨M¡A©ó¬O§Ú¦b¦³°ÝÃDªº¹q¸£¶}¤@­Ó·sÀÉ¡AµM«á§â©Ò¦³ªº¤u§@ªí¤@­Ó¤@­Ó½Æ»s¹L¥h
¦A­×¥¿¤@¨Ç¥~³¡³sµ²«áÀx¦s«á¦A¶}³o­Ó·sÀÉ¡A©Ò¦³¹q¸£´N³£¥i¥H°õ¦æ¤F

TOP

¦^´_ 1# kakinakata


    §Úªº°ÝÃD¸ò³o­ÓPO¤å §¹¥þ¤@¼Ë¡G
       1. ¦bA¥x¹q¸£½s¿èªº VBProject §t ActiveX±±¨î¶µ°õ¦æµL»~¡A²¾¨ìB¹q¸£¤£¯à°õ¦æ¡F
            µo²{ActiveX±±¨î¶µªº¦WºÙ¤w³Q§ï¦^­ì©l¦WºÙ¡A¥B¦n¹³³QÂê©wµLªk¦AÅܧó«ì´_¡F
            »Ý­n¦bB¹q¸£¥Î·sªÅ¥Õ¤u§@ï¤u§@­¶­«·s»s§@ ActiveX±±¨î¶µ¤Î½Æ»s­ì¨Óªº VBA µ{¦¡¤~¯à¥Î¡F
            ActiveXªº±±¨î¶µ¤£¯àCopy¡A§_«h¤]¤£¯à¥Î
       2. ¦bB¥x¹q¸£°µªº VBProject §t ActiveX¶µ¡A©ñ¨ì A¹q¸£§¹¥þ¥i¥H°õ¦æ

   ²{¦b¡AÁÙ¨S¸Ñ!!!

   Ä~Äò°lÂܪ©¥D PO ¤å¡A Ä~Äò¾Ç²ß

ÁÂÁ¼ö¤ßªº¤HÄ~Äò´£¨Ñ¥i¯àªº¸Ñ¨M¤èªk

TOP

¦^´_ 8# lpk187


    ¤W­±¦U¼Ó¼h´£¨Ñªº¤èªk³£°µ¤F¡A¥]§t¥h°£¼È¦sÀÉ+²M°£ µù¥U³sµ² + 2010­«Äé¡A°ÝÃD¨ÌÂÂ
1.win8 A ¹q¸£°µªº¤£¯à¥Î¦bB¹q¸£¡A¥i¥H¥Î¦b C ¹q¸£
2.¦bwin 7 B¹q¸£¥ÎªÅ¥Õ·sworkbook­«·s°µ A¹q¸£ªºÀɮפ¤ActiveX¤~¯à¥Î¡A¦b®³¦^¨ìA¹q¸£¤]¥i¥H¥Î
    ¡AA¹q¸£¥Î¹L«á®³¨ìB¥Î¤S±¾¤F

°ÝÃD¬O¬Æ»ò? A or B .......
©|«Ýµª®×

TOP

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