move cursor from to cell B after click on cell A

Unlock the cells in the two columns by highlighting them and going to format,cells,protection,uncheck locked.
Protect the sheet ensuring you have checked off "select unlocked cells" in the protection categories.

Originally Posted by davesexcel

Unlock the cells in the two columns by highlighting them and going to format,cells,protection,uncheck locked.
Protect the sheet ensuring you have checked off "select unlocked cells" in the protection categories.

thx,
but i neet to work with whole sheet, whith each cell (edit, paste, write...)
this solution disable this or?

i need something like in VBA is ActiveCell.Offset(0, 5).Select. And i run this by clicking on concrete cell where will be my function (in first row)

This Code placed in the worksheet module will work when you make a change in column G, it takes you to column W

Please Login or Register  to view this content.

i try it, but it seems, thats doesnt works. I gived it to my VBAProject-Modules-Module1.
Then i try something to write to column G, but nothings happend. Do i something wrong?


....ahh...sorry
i try it add in other place in moduls and it works.. great...and is it possible with clicking with mouse...something like hypertext ?

and...this works for change in whole column..but i want to have only one concrete cell (in first freeze row) to move to other column in last need active cursor

Originally Posted by danusko

i try it, but it seems, thats doesnt works. I gived it to my VBAProject-Modules-Module1.
Then i try something to write to column G, but nothings happend. Do i something wrong?


....ahh...sorry
i try it add in other place in moduls and it works.. great...and is it possible with clicking with mouse...something like hypertext ?

and...this works for change in whole column..but i want to have only one concrete cell (in first freeze row) to move to other column in last need active cursor

Pardon....

Originally Posted by danusko

so, this is not possible in excel or?
i think this part (clicking with mouse...something like hypertext )

i ask..if it possible to make something like command or something, thats make this
cursor is on cell A3
i click on cell a1 and the cursor moves in line 3 to column C. So after click, it will be on cell C3
and if will cursor on cell A6, again after the same cell with commnad or what it moves to the same column, but in other line (line 6).

So this command will always move cursor in concrete columnt, but in the same line. But a need posibility to write to all cell. So i can use lock and proteckt sheet..
do you know what i mean?...
is this possible?
thankeyou

Maybe supply a sample workbook with the directions you want to go to, this may help understand better.....

Originally Posted by danusko

because this code make "moving" always when i will write something to column G. But i need moving only after clicking on button (or command).

Where's the sample workbook?
Did you consider Worksheet_SelectionChange