• 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


  • 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.


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,