View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gord Dibben Gord Dibben is offline
external usenet poster
 
Posts: 22,906
Default protected sheet cursor movement

No.

There are other methods.

See Bob Phillips' site for using a Named Range

http://www.xldynamic.com/source/xld.xlFAQ0008.html

You could also use VBA event code to move any order you wish.

Post back if interested.


Gord Dibben MS Excel MVP

On Tue, 8 Apr 2008 11:09:01 -0700, Pa Maher
wrote:

When my worksheet is protected, when TAB is hit, the cursor move across then
down. Is there anyway to make it move down then across?