Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi folks,
Excel 2003. I have columns B-E unlocked from row 6 to the bottom of the worksheet. When I protect the worksheet with only select unlocked cells allowed (but not locked cells), I can select any unlocked cell with the mouse, but the tab and arrow keys behave very strangely. Sometimes it causes the cell pointer to jump up to row 6, and then the cell pointer will only move left and right through columns B-E in row 6 only, but never down. Often pressing one of them locks up Excel. If when protecting the sheet I also allow selecting locked cells, none of this strangeness happens. I've tried starting over building a new workbook, and this starts to happen at various times before I've put much in the sheet, and once it starts, it's toast. I can't tie it to anything I've done as I build the sheet. I've restarted Excel, rebooted, used /unregserver and /regserver, stood up and turned around three times -- all the stuff I'm supposed to do. It's a simple sheet, and it's a rush job. Makes me wish I'd taken up archery instead. Any ideas? Thanks. -- Regards from Virginia Beach, Earl Kiosterud www.smokeylake.com ----------------------------------------------------------------------- |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
why dont shift+arrow or ctrl+arrow work in 2007 | Excel Discussion (Misc queries) | |||
network file weirdness | Excel Discussion (Misc queries) | |||
VLOOKUP weirdness | Excel Worksheet Functions | |||
Excel weirdness!!!! | Excel Discussion (Misc queries) | |||
Conditional Sum weirdness . . . | Excel Worksheet Functions |