Hi Lolly,

You don't need a macro.

1) Select the cells that need to be edited, use the menu command
Format - Cells... Click the Protection tab, uncheck the Locked box

2) Then use the menu command Tools - Protection - Protect Sheet
Make sure the 'Select Locked Cells' option is unchecked and click ok.

3) Use menu command Tools - Options, click the Edit tab, change the
move selection after Enter direction to 'Right'

So, for instance, if you unlocked columns A to C and E to F in step 1
then Starting in cell A1 and pressing Enter repeatedly would select
cells A1, B1, C1, E1, F1, A2, B2....

Ed Ferrero
http://edferrero.m6.net/


In a spreadsheet using about 20 columns, after entering a letter in Column
C
or just pressing Enter, I need to jump from Column C to Column E. It has
been
brought to my attention that I need to create a Macro for this function,
but
unfortunately I cannot find one that works. I think the Macro may relate
to
SelectionChange.
There is a vlookup equation in Column D and that works brilliantly.

Help would be greatly appreciated.