LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 611
Default Arrow key weirdness

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why dont shift+arrow or ctrl+arrow work in 2007 Naguib Excel Discussion (Misc queries) 1 July 24th 07 04:40 PM
network file weirdness tamarakay Excel Discussion (Misc queries) 0 January 9th 07 08:02 PM
VLOOKUP weirdness Dave Excel Worksheet Functions 2 November 5th 06 03:22 PM
Excel weirdness!!!! MattShoreson Excel Discussion (Misc queries) 5 July 6th 05 01:43 PM
Conditional Sum weirdness . . . WillRn Excel Worksheet Functions 1 February 17th 05 10:46 PM


All times are GMT +1. The time now is 08:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"