Hello,

I created a spreadsheet to lookup patch panel positions on a fiber optic
network for technicians. I would like the technicians to have access to a
single cell where they enter data, after they press enter I want them to
remain in the same cell (not advance down the sheet) is this possible?

Go to Tools-Options, select edit tab and uncheck the box Move Selection
After Enter. They can still click out, but enter does not move them.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"FP Novice" wrote:

Hello,

I created a spreadsheet to lookup patch panel positions on a fiber optic
network for technicians. I would like the technicians to have access to a
single cell where they enter data, after they press enter I want them to
remain in the same cell (not advance down the sheet) is this possible?

Thanks John, it seems I should have been able to find that...

"John Bundy" wrote:

Go to Tools-Options, select edit tab and uncheck the box Move Selection
After Enter. They can still click out, but enter does not move them.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"FP Novice" wrote:

Hello,

I created a spreadsheet to lookup patch panel positions on a fiber optic
network for technicians. I would like the technicians to have access to a
single cell where they enter data, after they press enter I want them to
remain in the same cell (not advance down the sheet) is this possible?

John, this is what I was looking for but being that it is an Excel option the
change affects the attributes of the program as well when viewed on another
person's version it does not work unless they set the option to not move...

Can I make it so the not moving on carriage return works as a worksheet
attribute not a program setting?

"John Bundy" wrote:

Go to Tools-Options, select edit tab and uncheck the box Move Selection
After Enter. They can still click out, but enter does not move them.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"FP Novice" wrote:

Hello,

I created a spreadsheet to lookup patch panel positions on a fiber optic
network for technicians. I would like the technicians to have access to a
single cell where they enter data, after they press enter I want them to
remain in the same cell (not advance down the sheet) is this possible?

Private Sub Worksheet_Activate()
Application.MoveAfterReturn = False
End Sub

Private Sub Worksheet_Deactivate()
Application.MoveAfterReturn = True
End Sub

Copied to the sheet module.

Of course, will depend upon user enabling macros.


Gord Dibben MS Excel MVP

On Tue, 27 May 2008 05:23:01 -0700, FP Novice
wrote:

John, this is what I was looking for but being that it is an Excel option the
change affects the attributes of the program as well when viewed on another
person's version it does not work unless they set the option to not move...

Can I make it so the not moving on carriage return works as a worksheet
attribute not a program setting?

"John Bundy" wrote:

Go to Tools-Options, select edit tab and uncheck the box Move Selection
After Enter. They can still click out, but enter does not move them.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"FP Novice" wrote:

Hello,

I created a spreadsheet to lookup patch panel positions on a fiber optic
network for technicians. I would like the technicians to have access to a
single cell where they enter data, after they press enter I want them to
remain in the same cell (not advance down the sheet) is this possible?