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

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

¦^´_ 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

ÁÂÁ¨â¦ìªº¦^ÂС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

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

TOP

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

        ÀR«ä¦Û¦b : °µ¦n¨Æ¤£¯à¤Ö§Ú¤@¤H¡A°µÃa¨Æ¤£¯à¦h§Ú¤@¤H¡C
ªð¦^¦Cªí ¤W¤@¥DÃD