View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Neal Zimm Neal Zimm is offline
external usenet poster
 
Posts: 345
Default 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