1. Welcome to Chandoo.org Forums. Short message for you

    Hi Guest,

    Thanks for joining Chandoo.org forums. We are here to make you awesome in Excel. Before you post your first question, please read this short introduction guide. When posting or responding to questions please remember our values at Chandoo.org are: Humility, Passion, Fun, Awesomeness, Simplicity, Sharing Remember that we have people here for whom English is not there first language and we need to allow for this in our dealings.

  2. Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User


  3. When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

Cell selector moves after protecting sheet.

Discussion in 'Ask an Excel Question' started by StarMusk10, Mar 14, 2019.

  1. StarMusk10

    StarMusk10 New Member

    Good morning Guru's. I have an excel sheet (Org Target Dashboard) that has and Active X list box in it to control a chart. Before protecting the sheet I select a cell behind the chart to hide it after protection. Unfortunately, when I protect the sheet excel will select a cell at the bottom of the sheet. Every time I change the selection in the list box, the sheet jumps down to the selected cell. Unfortunately my sheet is too large to attach here.

    Thanks for your help,
  2. vletm

    vletm Excel Ninja

    Why do You select locked cell behind the chart?
    Could You select cell which is unlocked?
    ... if needs to hide something.
  3. Peter Bartholomew

    Peter Bartholomew Well-Known Member

    Either the cell under the chart needs to be unlocked or, if that is not possible, sheet protection need to be applied with 'Select locked cells' checked.

Share This Page