moving around a sheet
 

is it possible to control which cell is selected after enter is pressed?

for example, let's say i want enter to move the selected cell from A1, then
to B1, then to C1. but after enter is hit on C1, i want the next selected
cell to be A2.

Thanks, for any help

moving around a sheet
 

In the worksheet itself you can set specific cells as unprotected. Then
after you protect the worksheet you can hit tab to go between only the cells
you have specified.

1) select all cells in sheet and in the format screen protection tab --
make all cells locked
2) select cells A1,B1,C1,A2...etc. (all cells you want to be able to tab
between
3) right-click and select format
4) on the protection tab make sure that there is no checkmark next to locked.
5) tools protection protect sheet = click ok
6) use tab to select next cell.

"steve" wrote:

is it possible to control which cell is selected after enter is pressed?

for example, let's say i want enter to move the selected cell from A1, then
to B1, then to C1. but after enter is hit on C1, i want the next selected
cell to be A2.

Thanks, for any help

moving around a sheet
 

Select A1:C10

now keep hitting the tab key or the enter key (the enter key must be set to
move right in Tools=Options=Edit tab).

--
Regards,
Tom Ogilvy




"steve" wrote in message
...
is it possible to control which cell is selected after enter is pressed?

for example, let's say i want enter to move the selected cell from A1,
then
to B1, then to C1. but after enter is hit on C1, i want the next selected
cell to be A2.

Thanks, for any help

moving around a sheet
 

might be able to assign a on enter event to the cell.

"steve" wrote:

is it possible to control which cell is selected after enter is pressed?

for example, let's say i want enter to move the selected cell from A1, then
to B1, then to C1. but after enter is hit on C1, i want the next selected
cell to be A2.

Thanks, for any help