Notice: This website is an unofficial Microsoft Knowledge Base (hereinafter KB) archive and is intended to provide a reliable access to deleted content from Microsoft KB. All KB articles are owned by Microsoft Corporation. Read full disclaimer for more details.

Sheet focus changes when you click a button to run a macro to protect or unprotect some Excel 2013 worksheets


View products that this article applies to.

Symptoms

When you click a button to run a macro to protect or unprotect some worksheets in a workbook in Microsoft Excel 2013, the sheet focus changes instead of staying on the sheet that contains the button.

↑ Back to the top


Resolution

To resolve this issue, apply the following update:
2850006 Description of the Excel 2013 hotfix package (Excel-x-none.msp): December 10, 2013


Registry key information

Important
Follow the steps in this section carefully. Serious problems might occur if you modify the registry incorrectly. Before you modify it, back up the registry for restoration in case problems occur.


After you install this hotfix package, you can follow these steps to enable this hotfix:
  1. Click Start, click Run, type regedit in the Open box, and then click OK.
  2. Locate and then select the following registry subkey:
    HKEY_CURRENT_USER\Software\Microsoft\Office\15.0\Excel\Options\
  3. On the Edit menu, point to New, and then click DWORD Value.
  4. Type ExcelResetSheetAfterProtection, and then press Enter.
  5. In the Details pane, right-click ExcelResetSheetAfterProtection, and then click Modify.
  6. In the Value data box, type 1, and then click OK.
  7. Exit Registry Editor.

↑ Back to the top


Status

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

↑ Back to the top


Keywords: kbqfe, kbexpertisebeginner, kbsurveynew, kbbug, kbfix, kb

↑ Back to the top

Article Info
Article ID : 2827321
Revision : 1
Created on : 1/7/2017
Published on : 12/12/2013
Exists online : False
Views : 144