View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Tom Ogilvy Tom Ogilvy is offline
external usenet poster
 
Posts: 27,285
Default This seems weird to me

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