Something "Odd", Sheet Protection, Locked Cells
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
|