cursor movement

[Guest]

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

 

[Gord Dibben]

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

 

[Guest]

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]

No.

Sheet must be protected.


Gord

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?

 

[Guest]

Gord, thank you for your information.

Paulo Couto

 

[David McRitchie]

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.