Article ID: 978753 - View products that this article applies to.
Expand all | Collapse all

Symptoms

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.

Cause

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:
HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common
In earlier versions of Office, the registry entries are located at the following subkey:
HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common


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.

Fix it for me

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. For Windows 8
Collapse this imageExpand this image
assets folding start expanded
Collapse this imageExpand this image
assets fixit1
Fix this problem
Microsoft Fix it 20105
Collapse this imageExpand this image
assets fixit2

Collapse this imageExpand this image
assets folding end

For Windows 7, Windows Vista, Windows XP, Windows Server 2008, Windows Server 2003
Collapse this imageExpand this image
assets folding start expanded
Collapse this imageExpand this image
assets fixit1
Fix this problem
Microsoft Fix it 50347
Collapse this imageExpand this image
assets fixit2
Collapse this imageExpand this image
assets folding end

Notes
Collapse this imageExpand this image
assets folding start collapsed
  • This wizard may be in English only. However, the automatic fix also works for other language versions of Windows.
  • If you are not on the computer that has the problem, save the Fix it solution to a flash drive or a CD and then run it on the computer that has the problem.
  • We would appreciate your feedback. To provide feedback or to report any issues with this solution, please leave a comment on the "Fix it for me" blog or send us an email message.
Collapse this imageExpand this image
assets folding end collapsed

Let me fix it myself

To work around this problem yourself, enable the settings manually. To do this, use one of the following methods:

Method 1

  1. Start an Office 2010 application.
  2. On the Developer tab, click Visual Basic.

    Note If you start Microsoft Access 2010, click Visual Basic on the Database Tools tab.
  3. On the Tools menu, click Options.
  4. In the Options dialog box, select any option that you want to enable, and then click OK.

Method 2

Important 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:
322756 How to back up and restore the registry in Windows
  1. Click Start, click Run, type regedit, and then click OK.
  2. Locate the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common
  3. On the File menu, click Export.
  4. In the Export Registry File dialog box, select a path and a name for the exported file.
  5. Make sure that the Selected branch option is enabled, and then click Save.
  6. Open the exported file in Notepad.
  7. Locate the following string:
    [HKEY_CURRENT_USER\Software\Microsoft\VBA\6.0\Common]
    Then, change this string to the following:
    [HKEY_CURRENT_USER\Software\Microsoft\VBA\7.0\Common]
  8. Save and then close the file in Notepad.
  9. In Registry Editor, click Import on the File menu.
  10. In the Export Registry File dialog box, select the file that you just saved, and then click Open.
  11. Click OK.

Status

Microsoft has confirmed that this is a problem in the Microsoft products that are listed in the "Applies to" section.

More information

To make the Developer tab appear in the ribbon of certain Microsoft Office 2010 applications, follow these steps:
  1. On the File tab, click Options.
  2. On the Customize Ribbon tab, click to select the Developer check box under the Customize the Ribbon section, and then click OK.

Properties

Article ID: 978753 - Last Review: July 2, 2013 - Revision: 6.0
Applies to
  • Microsoft Access 2010
  • Microsoft Excel 2010
  • Microsoft PowerPoint 2010
  • Microsoft Word 2010
Keywords: 
kbmsifixme kbfixme kbtshoot kbexpertiseadvanced kbsurveynew kbprb KB978753

Give Feedback

 

Contact us for more help

Contact us for more help
Connect with Answer Desk for expert help.
Get more support from smallbusiness.support.microsoft.com