Select the product you need help with
- Internet Explorer
- Windows Phone
- More products
Some settings for the Visual Basic Editor that you enabled in an earlier version of an Office application are disabled in Office 2010
Article ID: 978753 - View products that this article applies to.
Consider the following scenario. You create a file in a 2007 Microsoft Office application or in an earlier version of the application. You notice that some settings for the Microsoft Visual Basic Editor are enabled in the application, such as the Require Variable Declaration option and the Compile on Demand option. When you open the file in a Microsoft Office 2010 application, these settings are disabled.
This problem occurs because Visual Basic for Applications (VBA) is upgraded to version 7.0 in Microsoft Office 2010. Therefore, the registry entries that correspond to the settings for the Visual Basic editor are located under a different subkey. In Office 2010, the registry entries are located under the following subkey:
In earlier versions of Office, the registry entries are located at the following subkey:
To have us fix this problem for you, go to the "Fix it for me" section. If you would rather work around this problem yourself, go to the "Let me fix it myself" section.
To fix this problem automatically, click the Fix this problem link. Then click Run in the File Download dialog box, and follow the steps in this wizard.
Fix this problem
Microsoft Fix it 50347
Note This wizard may be in English only; however, the automatic fix also works for other language versions of Windows.
Note If you are not on the computer that has the problem, you can save the automatic fix to a flash drive or to a CD, and then you can run it on the computer that has the problem.
To work around this problem yourself, enable the settings manually. To do this, use one of the following methods:
Method 2Important This section, method, or task contains steps that tell you how to modify the registry. However, serious problems might occur if you modify the registry incorrectly. Therefore, make sure that you follow these steps carefully. For added protection, back up the registry before you modify it. Then, you can restore the registry if a problem occurs. For more information about how to back up and restore the registry, click the following article number to view the article in the Microsoft Knowledge Base:
(http://support.microsoft.com/kb/322756/ )How to back up and restore the registry in Windows
Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.
To make the Developer tab appear in the ribbon of certain Microsoft Office 2010 applications, follow these steps: