Protect controls and linked cells on a worksheet

You may want to add protection to Form controls and ActiveX controls to prevent users from moving, changing, or deleting controls.

  1. If one or more controls is an ActiveX control:

    1. Make sure that the Developer tab is available.

      Display the Developer tab

      1. Click the Microsoft Office Button Office button image, and then click Excel Options.

      2. In the Popular category, under Top options for working with Excel, select the Show Developer tab in the Ribbon check box, and then click OK.

        Note   The Ribbon is a component of the Microsoft Office Fluent user interface.

    2. Make sure that you are in design mode. On the Developer tab, in the Controls group, turn on Design Mode Button image.

  2. Select the control that you want to protect.

    For more information, see Select or deselect controls on a worksheet.

  3. To prevent a user from moving, sizing, or deleting a control, right-click the selection, and then click Format Control.

  4. On the Protection tab, select the Locked check box.

  5. If the control has a linked cell, unlock the cell so that the control can write to it, and then hide the cell so that a user cannot cause unexpected problems by modifying the current value. To unlock the cell:

    1. On the Home tab, in the Cells group, click Format, and then click Format Control.

      The Cells group on the Home tab

    2. On the Protection tab, clear the Locked check box, and then click OK.

      Then, hide the column or row that contains the linked cell, or move the contents of the linked cell to a separate worksheet, and then hide that worksheet.

      For more information, see Hide or display rows and columns and Hide or display worksheets or workbooks.

  6. To prevent users from changing the protections on the cells and controls that you have set, protect both the worksheet and the workbook.

    For more information, see Protect worksheet or workbook elements.

Applies To: Excel 2007

Was this information helpful?

Yes No

How can we improve it?

255 characters remaining

To protect your privacy, please do not include contact information in your feedback. Review our privacy policy.

Thank you for your feedback!

Change language