A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » General Discussion
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Up down arrow keys do not select cells if select locked cells unch



 
 
Thread Tools Display Modes
  #1  
Old May 17th, 2009, 07:18 PM posted to microsoft.public.excel.misc
roandrob[_2_]
external usenet poster
 
Posts: 3
Default Up down arrow keys do not select cells if select locked cells unch

If I protect my work book and do not allow selection of locked cells the
arrow keys and enter key do not select cells ( unlocked ) in the up down
direction. I can use arrow keys to select cells right or left.
  #2  
Old May 17th, 2009, 11:14 PM posted to microsoft.public.excel.misc
ART
external usenet poster
 
Posts: 432
Default Up down arrow keys do not select cells if select locked cells unch

When you protect the sheet, when you press enter or tab, it goes to the next
available cell thats unlocked. The same applies to the up and down arrow. It
just may seem not to go in the direction you want since you might have locked
a big amount of cells, so it seems as it goes up or down when you want to go
right or left, and vice versa.

"roandrob" wrote:

If I protect my work book and do not allow selection of locked cells the
arrow keys and enter key do not select cells ( unlocked ) in the up down
direction. I can use arrow keys to select cells right or left.

  #3  
Old May 18th, 2009, 12:16 AM posted to microsoft.public.excel.misc
roandrob[_2_]
external usenet poster
 
Posts: 3
Default Up down arrow keys do not select cells if select locked cells

Thank You for the reply ! But No this is not the case. I have contiguous
cells above and below the curser which are not protected. If I allow the user
to select protected cells when I protect the sheet then everything behaves
properly except of course protected cells can be selected but not changed.
What I have now wit only allow unprotected cells to be selected is a
situation where the selection will not go in any direction except right or
left and if I want to change rows I must use the mouse as when the selection
reaches the end of protected cells no further movement is allowed.

"art" wrote:

When you protect the sheet, when you press enter or tab, it goes to the next
available cell thats unlocked. The same applies to the up and down arrow. It
just may seem not to go in the direction you want since you might have locked
a big amount of cells, so it seems as it goes up or down when you want to go
right or left, and vice versa.

"roandrob" wrote:

If I protect my work book and do not allow selection of locked cells the
arrow keys and enter key do not select cells ( unlocked ) in the up down
direction. I can use arrow keys to select cells right or left.

  #4  
Old May 18th, 2009, 12:48 AM posted to microsoft.public.excel.misc
roandrob[_2_]
external usenet poster
 
Posts: 3
Default Up down arrow keys do not select cells if select locked cells



"roandrob" wrote:

Thank You for the reply ! But No this is not the case. I have contiguous
cells above and below the curser which are not protected. If I allow the user
to select protected cells when I protect the sheet then everything behaves
properly except of course protected cells can be selected but not changed.
What I have now with only allow unprotected cells to be selected is a
situation where the selection will not go in any direction except right or
left and if I want to change rows I must use the mouse as when the selection
reaches the end of unprotected cells no further movement is allowed.


PS I am useing Office 2003 Pro

"art" wrote:

When you protect the sheet, when you press enter or tab, it goes to the next
available cell thats unlocked. The same applies to the up and down arrow. It
just may seem not to go in the direction you want since you might have locked
a big amount of cells, so it seems as it goes up or down when you want to go
right or left, and vice versa.

"roandrob" wrote:

If I protect my work book and do not allow selection of locked cells the
arrow keys and enter key do not select cells ( unlocked ) in the up down
direction. I can use arrow keys to select cells right or left.

 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 12:03 AM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.