Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
In my application I've been able to lock and unlock cells thru VBA, and
protect and unprotect worksheets just fine. The postings I looked at don't seem to cover my situation below. Today, when testing, I manually UNPROTECTED the worksheet. Using the right arrow key I tried to scroll to a cell at the right edge of the screen, I could not "get there". The cursor would only go to the normally unlocked cells. I double checked the sheet protection under "Tools" and the menu said "Protect sheet" meaning to me that the sheet was NOT protected. In the application when I protect the sheet, I enable only selection of UNlocked cells. After a couple of head scratchings, on a lark I saved and closed the workbook, opened it again, and was able to get to the cell I wanted. NO other settings were changed or macros were run. What's up with this? thanks, Neal -- Neal Z |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Allow "List" to work in a locked sheet | Excel Worksheet Functions | |||
Protect sheet unchecking "Select locked cells" has undesiredresults | Excel Discussion (Misc queries) | |||
sheet protected but cells "cleared of all" become locked | Excel Discussion (Misc queries) | |||
Stop users from accessing "Protection" option from "Tools" menu | Excel Programming | |||
Protect shouldn't default to "allow users to select locked cells" | Setting up and Configuration of Excel |