G'day there Peoples,

Whilst investigating my scrolling troubles (outlined in another
post), I took the following actions.

Created a new blank workbook. Removed all AddIns. Selected Row 10,
on first sheet and then down to bottom of sheet. Set selected cells
protection to "Unlocked". I then protected the sheet, ticking only
"Select Unlocked Cells". That way I should have been able to select all
cells in rows below 9.

I had the cursor in some random cell in about row 14, column 5 or
6, and then I pressed the down arrow. The selected cell immediately
jumped to column 1, row 10 (top, left unlocked cell) and refused to move
no matter which arrow key I pressed.

Is this normal? What changes with regard to scrolling when a
worksheet is protected? I have no idea of whether this is something I
can resolve, or whether I just have to leave the whole thing
unprotected. That's not a real good option.

Does anyone know how this is supposed to work?

See ya
Ken McLennan
Qld, Australia

depends what the "locked" attribute is in the style "Normal"
in the template for the blank workbook.


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Ken McLennan wrote:

G'day there Peoples,

Whilst investigating my scrolling troubles (outlined in another
post), I took the following actions.

Created a new blank workbook. Removed all AddIns. Selected Row 10,
on first sheet and then down to bottom of sheet. Set selected cells
protection to "Unlocked". I then protected the sheet, ticking only
"Select Unlocked Cells". That way I should have been able to select all
cells in rows below 9.

I had the cursor in some random cell in about row 14, column 5 or
6, and then I pressed the down arrow. The selected cell immediately
jumped to column 1, row 10 (top, left unlocked cell) and refused to move
no matter which arrow key I pressed.

Is this normal? What changes with regard to scrolling when a
worksheet is protected? I have no idea of whether this is something I
can resolve, or whether I just have to leave the whole thing
unprotected. That's not a real good option.

Does anyone know how this is supposed to work?

See ya
Ken McLennan
Qld, Australia

G'day there keepITcool,

depends what the "locked" attribute is in the style "Normal"
in the template for the blank workbook.

I'm not sure that I understand why that should make a difference.
As it happens, the "Protection" attribute actually is "Locked". This is
apparently correct as I had to deliberately unlock the cells to make my
little experiment. However I don't see why that should stop scrolling
from working. I would have thought it would just scroll through the
unlocked cells and stop at the locked rows.

There's obviously something that I don't understand about how all
of this works, but I don't even know where to start looking.

See ya
Ken McLennan
Qld, Australia

G'day there again, keepITcool,

from working. I would have thought it would just scroll through the
unlocked cells and stop at the locked rows.

I extended my investigation a little and found that if I opened
Options | International and then in the "Right-to-left" section selected
Visual instead of Logical curser movement, I was able to move the cursor
with the arrow keys while protection was on.

When protection was removed, and Options reopened I found that
Logical had been selected automatically. However, the cursor still moved
except that the arrow keys now cycle it around the range A10:J26. I have
no idea of why it's chosen those cells. Still, no matter which arrow key
I use, that area determines the bounds of cursor movement.

Any ideas at all?
--
Ken McLennan
Qld, Australia

I performed the actions you describe and I have no problem tabbing or moving
through the unlocked cells using the arrow keys. If I made the window small
enough to require scrolling, then the window scrolled as well.

Perhaps you didn't unlock the cells you thought you did?

xl2002
--
Regards,
Tom Ogilvy

"Ken McLennan" wrote in message
...
G'day there keepITcool,

depends what the "locked" attribute is in the style "Normal"
in the template for the blank workbook.

I'm not sure that I understand why that should make a difference.
As it happens, the "Protection" attribute actually is "Locked". This is
apparently correct as I had to deliberately unlock the cells to make my
little experiment. However I don't see why that should stop scrolling
from working. I would have thought it would just scroll through the
unlocked cells and stop at the locked rows.

There's obviously something that I don't understand about how all
of this works, but I don't even know where to start looking.

See ya
Ken McLennan
Qld, Australia

G'day there Tom,

I performed the actions you describe and I have no problem tabbing or moving
through the unlocked cells using the arrow keys. If I made the window small
enough to require scrolling, then the window scrolled as well.

Well, that's what I would have expected with mine too.

Perhaps you didn't unlock the cells you thought you did?

Always a possibility, so I just went back & tried again. Selected
Row 10. Selected to the bottom of the sheet and then right clicked.
Formatted the cells and unchecked the "Locked" box on the Protection
tab. Locked the sheet with only the "Protect Worksheet and Contents of
Locked Cells" & "Select Unlocked Cells" checkboxes checked. Now, lo &
behold, I find it scrolls only in a four cell range A10:B11!!

I have absolutely no idea of what is going on!!

Hoping someone has an idea,
--
Ken McLennan
Qld, Australia

I see what you mean....

and it has to do with Empty Cells

Although all cells in 10:65536 can be selected with the mouse
they cannot be navigated to with the keyboard it they are beyond the first
empty column.


when you press ENTER or TAB the cursor moves within the boundaries
of the currentregion +1 column +1row.

and will NOT jump to empty cells (except when adjacent to the currentcell)


it's behaves like it does in DataEntry Mode.
(also does this in xl97/ xlXP and xl2003)


keepITcool

< email : keepitcool chello nl (with @ and .)
< homepage: http://members.chello.nl/keepitcool


Ken McLennan wrote:

G'day there Tom,

I performed the actions you describe and I have no problem tabbing or
moving through the unlocked cells using the arrow keys. If I made
the window small enough to require scrolling, then the window
scrolled as well.

Well, that's what I would have expected with mine too.

Perhaps you didn't unlock the cells you thought you did?

Always a possibility, so I just went back & tried again. Selected
Row 10. Selected to the bottom of the sheet and then right clicked.
Formatted the cells and unchecked the "Locked" box on the Protection
tab. Locked the sheet with only the "Protect Worksheet and Contents of
Locked Cells" & "Select Unlocked Cells" checkboxes checked. Now, lo &
behold, I find it scrolls only in a four cell range A10:B11!!

I have absolutely no idea of what is going on!!

Hoping someone has an idea,