I know that in a worksheet with both protected and unprotected cells, pushing the "tab" key will move the cursor to the next unprotected cell. Is there a way to configure Excel 07 so that pushing the "enter" key will have the same effect?
Thanks !!
I know that in a worksheet with both protected and unprotected cells, pushing the "tab" key will move the cursor to the next unprotected cell. Is there a way to configure Excel 07 so that pushing the "enter" key will have the same effect?
Thanks !!
Last edited by The Skipper; 02-22-2013 at 04:06 PM.
Set the Move after return direction to Right.
Entia non sunt multiplicanda sine necessitate
shg.......had no effect. Cursor moves right, but into the next cell not the next unprotected cell. Any thoughts?
When you protect the sheet, disallow selection of locked cells.
SHG>>>>>>>>Thanks !! Problem solved.
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks