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: 1
Default Move direction problem when protected

I have a 5 sheet workbook in Excel 2002, sp3 that I have protected and
unprotected cells in each worksheet. Something happened recently that I can
not figure out . when I turn protection on for each worksheet all is fine
except in the first worksheet. The up, down, left and right move arrows keys
will now only move to the left or right and only in one row. There are
several rows and columns with unprotected cells and the direction keys work
fine when protected with "select protected cells and unprotected cells" is
checked but when only "select unprotected cells" is checked the problem
occurs.
 
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
how do I move selection after enter direction plasiter Excel Discussion (Misc queries) 2 September 22nd 08 06:18 PM
My arrow keys in Excel move the opposite direction roroark Excel Discussion (Misc queries) 1 August 15th 08 04:17 PM
Cursor does not move on protected sheet pseudo_pro Excel Discussion (Misc queries) 5 December 12th 07 08:00 PM
Problem trying to move between cells on a protected worksheet. ayanna Excel Discussion (Misc queries) 0 April 26th 05 09:18 PM
In Excel 2000, can I change the direction of the move selection a. GTP Excel Discussion (Misc queries) 2 January 7th 05 01:20 AM


All times are GMT +1. The time now is 04:12 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"