How can i movement the cursor directly from column A to c?

See a couple of methods at Bob Phillips' site

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

You can also use event code to jump around through a set range of cells.

If interested, post back.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 08:27:0.0 -0700, Paulo Couto <Paulo
wrote:

How can i movement the cursor directly from column A to c?

The exemple number 1 (Unlock the cells you want to TAB to then protect the
worksheet.) solve 50% of my problem. I would do this whithout protect the
worksheet. Can i?


"Gord Dibben" wrote:

See a couple of methods at Bob Phillips' site

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

You can also use event code to jump around through a set range of cells.

If interested, post back.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 08:27:0.0 -0700, Paulo Couto <Paulo
wrote:

How can i movement the cursor directly from column A to c?

No.

Sheet must be protected.


Gord



On Tue, 9 Oct 2007 14:38:02 -0700, Paulo Couto
wrote:

The exemple number 1 (Unlock the cells you want to TAB to then protect the
worksheet.) solve 50% of my problem. I would do this whithout protect the
worksheet. Can i?


"Gord Dibben" wrote:

See a couple of methods at Bob Phillips' site

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

You can also use event code to jump around through a set range of cells.

If interested, post back.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 08:27:0.0 -0700, Paulo Couto <Paulo
wrote:

How can i movement the cursor directly from column A to c?

Gord, thank you for your information.

Paulo Couto

"Gord Dibben" wrote:

No.

Sheet must be protected.


Gord



On Tue, 9 Oct 2007 14:38:02 -0700, Paulo Couto
wrote:

The exemple number 1 (Unlock the cells you want to TAB to then protect the
worksheet.) solve 50% of my problem. I would do this whithout protect the
worksheet. Can i?


"Gord Dibben" wrote:

See a couple of methods at Bob Phillips' site

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

You can also use event code to jump around through a set range of cells.

If interested, post back.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 08:27:0.0 -0700, Paulo Couto <Paulo
wrote:

How can i movement the cursor directly from column A to c?

You can do what you want with an Event macro.

The default setting in Excel is to position to the cell
below after entering data. You can change the default
behavior with Tools, Options, ...

But you can have complete control with an Event
Macro such as the next cell to select, continue at the
beginning of the next row. You might want to include
a cell marker to activate/deactivate the repositioning.

Worksheet_SelectionChange (#ws_sc)
Worksheet_SelectionChange to prevent entry past a column
http://www.mvps.org/dmcritchie/excel/event.htm#ws_sc
Will only apply to the sheet you install if for.

--
HTH,
David McRitchie, Microsoft MVP -- Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm


"Paulo Couto" wrote in message ...
Gord, thank you for your information.

Paulo Couto

"Gord Dibben" wrote:

No.

Sheet must be protected.


Gord



On Tue, 9 Oct 2007 14:38:02 -0700, Paulo Couto
wrote:

The exemple number 1 (Unlock the cells you want to TAB to then protect the
worksheet.) solve 50% of my problem. I would do this whithout protect the
worksheet. Can i?


"Gord Dibben" wrote:

See a couple of methods at Bob Phillips' site

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

You can also use event code to jump around through a set range of cells.

If interested, post back.


Gord Dibben MS Excel MVP

On Tue, 9 Oct 2007 08:27:0.0 -0700, Paulo Couto <Paulo
wrote:

How can i movement the cursor directly from column A to c?