Results 1 to 3 of 3

Thread: [RESOLVED] [Excel 2003] Protected Sheet Disables Scroll Wheel & Ctrl-End

  1. #1

    Thread Starter
    Addicted Member
    Join Date
    Mar 2009
    Posts
    157

    Resolved [RESOLVED] [Excel 2003] Protected Sheet Disables Scroll Wheel & Ctrl-End

    So, the title of this post says it all. I've protected some sheets in a workbook I've created for someone else, so they won't accidentally mess up any formulas, etc. I was just finishing checking it when I discovered that I could no longer use the scroll wheel on my mouse to scroll the protected sheets, neither could I use ctrl-end to get to the end of the data range. When I unprotect the sheet, these functions are not disabled anymore. Does anyone know how to fix this?

    Thanks in advance!

  2. #2

    Thread Starter
    Addicted Member
    Join Date
    Mar 2009
    Posts
    157

    Re: [Excel 2003] Protected Sheet Disables Scroll Wheel & Ctrl-End

    Evidently Excel just glitched for me. I tried this in a different workbook, and protecting the sheet didn't affect the use of my scroll wheel or ctrl-end, so I just closed out my workbook and re-opened it, and now it works fine. Oopsie. Sorry for the post.

  3. #3
    I'm about to be a PowerPoster! Hack's Avatar
    Join Date
    Aug 2001
    Location
    Searching for mendhak
    Posts
    58,333

    Re: [RESOLVED] [Excel 2003] Protected Sheet Disables Scroll Wheel & Ctrl-End

    Don't be sorry for the thread. Nothing is ever wasted. If this happened to you, it could happen to someone else and if they did a search on the topic, they would find this.

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts
  •  



Click Here to Expand Forum to Full Width