ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Something "Odd", Sheet Protection, Locked Cells (https://www.excelbanter.com/excel-programming/367793-something-odd-sheet-protection-locked-cells.html)

Neal Zimm

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


All times are GMT +1. The time now is 05:23 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com