Microsoft Excel 2007 does not run add-ins in earlier versions-VBA
Hi
Here's how to troubleshoot running add-ins created in versions earlier than Microsoft Excel 2007.
Installing the Excel 207 are not enabled add-ins to VBA projects. With this, when you run a spreadsheet that has VBA Tools, such as COMBO BOX-COMMAND BUTTON, you receive error messages due to lack of management component of Visual Basic Applications.
To resolve the problem, follow the step below:
1. click on Start Menu- Settings - Control Panel- Add and remove programs.
2. Select the Excel 2007 and click Modify.
3. in the installation options, select the option to add or remove features and select components of project management in VBA.
4. click Install then Next and wait for the end.
5. Log on the user account and access the Microsoft Excel 2007.
6. click on the Office Buttonin the upper-left corner of the screen and select "Excel Options" will open a screen of advanced settings.
7. Select the option "Add-ins" and then select the option to install VBA components.
8. click Add and restart Excel.
By following this step by step the problem will be solved.
Here's how to troubleshoot running add-ins created in versions earlier than Microsoft Excel 2007.
Installing the Excel 207 are not enabled add-ins to VBA projects. With this, when you run a spreadsheet that has VBA Tools, such as COMBO BOX-COMMAND BUTTON, you receive error messages due to lack of management component of Visual Basic Applications.
To resolve the problem, follow the step below:
1. click on Start Menu- Settings - Control Panel- Add and remove programs.
2. Select the Excel 2007 and click Modify.
3. in the installation options, select the option to add or remove features and select components of project management in VBA.
4. click Install then Next and wait for the end.
5. Log on the user account and access the Microsoft Excel 2007.
6. click on the Office Buttonin the upper-left corner of the screen and select "Excel Options" will open a screen of advanced settings.
7. Select the option "Add-ins" and then select the option to install VBA components.
8. click Add and restart Excel.
By following this step by step the problem will be solved.
Comentários
Postar um comentário
ATENÇÃO: Seu comentário é muito importante para nós e esperamos que você compartilhe suas opiniões e sugestões abaixo. No entanto, lembramos que é de inteira responsabilidade dos usuários seguir as dicas postadas no Blog DicasQueFunfa. Pedimos que evite comentários ofensivos, ilegais ou prejudiciais, pois esses não serão tolerados e serão removidos. Agradecemos sua colaboração e esperamos que suas contribuições enriqueçam ainda mais nosso conteúdo.