• 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

    Hui...

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

StarMusk10

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,
Todd
 
Back
Top