I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?

Have you tried under Tools|Options|Edit to change the Enter key direction to
"Right"?

"Wayne Lee" wrote:

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?

Thank you so much for the tip. I had set it up as it was in the Mac, but your
correct, you have to change ot to "right"

"Kassie" wrote:

Have you tried under Tools|Options|Edit to change the Enter key direction to
"Right"?

"Wayne Lee" wrote:

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?

Also, you could reprotect the sheet and select the option to only allow the user
to select unlocked cells


"Wayne Lee" <Wayne wrote in message
...
: I just came out of a Mac and when I protected a spreadsheet I could hit Enter
: to move to the next unprotected cell. In the PC version, enter moves down a
: cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
: to change the function of the enter key?

Wayne

You will have to stick with the Tab key to move to unlocked cells.

Kassie's ENTER key suggestion will not work.

No matter which direction you set the ENTER key to move, it will not go to
next unlocked cell as the Tab key will.


Gord Dibben Excel MVP

On Thu, 28 Apr 2005 06:42:08 -0700, Wayne Lee
wrote:

Thank you so much for the tip. I had set it up as it was in the Mac, but your
correct, you have to change ot to "right"

"Kassie" wrote:

Have you tried under Tools|Options|Edit to change the Enter key direction to
"Right"?

"Wayne Lee" wrote:

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?

OOPS!

Sorry Kassie and Wayne.

If running xl 2002 or 2003 you can, when protecting the sheet, allow selection
of unlocked cells only.

Then the ENTER key set to go right will work.

Earlier versions did not have this feature.


Gord Dibben Excel MVP

On Thu, 28 Apr 2005 15:57:53 -0700, Gord Dibben <gorddibbATshawDOTca wrote:

Wayne

You will have to stick with the Tab key to move to unlocked cells.

Kassie's ENTER key suggestion will not work.

No matter which direction you set the ENTER key to move, it will not go to
next unlocked cell as the Tab key will.


Gord Dibben Excel MVP

On Thu, 28 Apr 2005 06:42:08 -0700, Wayne Lee
wrote:

Thank you so much for the tip. I had set it up as it was in the Mac, but your
correct, you have to change ot to "right"

"Kassie" wrote:

Have you tried under Tools|Options|Edit to change the Enter key direction to
"Right"?

"Wayne Lee" wrote:

I just came out of a Mac and when I protected a spreadsheet I could hit Enter
to move to the next unprotected cell. In the PC version, enter moves down a
cell. I have to use Tab to move from unlocked cell to unlocked cell. Anyway
to change the function of the enter key?