![]() |
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