how to confine the range of movement of cursor
 

for example, if i just want to let the cursor in worksheet move from column
A to V and / or row 1 to 50,
except using VBA, excel have function key to that?
(hide cell or cell header is not suitable for my case)

how to confine the range of movement of cursor
 

Are you trying to restrict the area that a user can
select?

Each worksheet has a "scroll range" property. This can be
set to say B5:G25 and would prevent ant cell outside
this range from being selected
The only other way is to use VBA.
Protection only stope the user from editing cells or
seeing their contents...protection does not stop a cell
being selected.

If you want to restrict movement to the top left area of
a worksheet, eg A1 to z50, try this: first "split" the
screen so that the splits are just outside the area you
want...then freeze it.
Move the applications edges so that its just on the edges
of the frozen area. Now the user can still scroll off
screen but he'll only see the required frame. personally
I don't like this - and it doesn't satisfy the user
request.

So, the solution is VBA

Patrick Molloy
Microsoft Excel MVP



-----Original Message-----
for example, if i just want to let the cursor in
worksheet move from column
A to V and / or row 1 to 50,
except using VBA, excel have function key to that?
(hide cell or cell header is not suitable for my case)




.

how to confine the range of movement of cursor
 

thanks for kindly reply.

i'm not fully understand the method of confining the movement of cursor
outside the selected cells area.

let say i don't know where is application of " scroll range" property &
"Move the applications edges "


"Patrick Molloy" <xl_expert@xxxhotmail ???
???...
Are you trying to restrict the area that a user can
select?

Each worksheet has a "scroll range" property. This can be
set to say B5:G25 and would prevent ant cell outside
this range from being selected
The only other way is to use VBA.
Protection only stope the user from editing cells or
seeing their contents...protection does not stop a cell
being selected.

If you want to restrict movement to the top left area of
a worksheet, eg A1 to z50, try this: first "split" the
screen so that the splits are just outside the area you
want...then freeze it.
Move the applications edges so that its just on the edges
of the frozen area. Now the user can still scroll off
screen but he'll only see the required frame. personally
I don't like this - and it doesn't satisfy the user
request.

So, the solution is VBA

Patrick Molloy
Microsoft Excel MVP



-----Original Message-----
for example, if i just want to let the cursor in
worksheet move from column
A to V and / or row 1 to 50,
except using VBA, excel have function key to that?
(hide cell or cell header is not suitable for my case)




.