Odd behavior on Ctrl-Page Down

[Eric_in_EVV]

Why would Ctrl-Page Down not take me to the next tab in a worksheet ? In
this particular file the Ctrl-Page Down takes me to the next tab except for
when I hit one particular tab...then Ctrl-Page Down effectively shifts the
columns displayed by one screen width. Any ideas ?

Thanks !

 

[Dave Peterson]

ctrl-pagedown wasn't affected by this setting for me in xl2003--but maybe you
hit a different key...

Just in case, I'd look at a Lotus 123 transition setting.

In xl2003 menus:
tools|options|transition tab
Uncheck Transition navigation keys

(I'd uncheck all those settings if I were you.)

If that setting was not checked, then this answer is completely wrong.

My next suggestion would be to verify that it's really ctrl-pagedown that's
causing the trouble.

If it is, then I'd look for a macro that's doing something.

You could open excel in safe mode:
close excel
windows start button|run
type
excel /safe
and hit enter

Open your workbook and test it.

If the keystroke works ok, it could be a macro. (Macros are disabled in safe
mode.)

 

[Eric_in_EVV]

I'm using Excel 2007....suppose I should have mentioned that earlier...sorry.
Lotus transition settings are all OFF...there are macros active, but none of
them have shortcuts involving the ctrl-page down. With Macros disabled I
still have the same problem.

Oh...one more thing I should have mentioned...and I bet this is what is
causing it...the worksheets and workbook have protection turned on. I should
look at this tab versus the others and see what's different in the protection.

 

[Dave Peterson]

It's the worksheet protection that's causing the problem.

I think I've read posts that describe this bug.

You may want to remove the worksheet protection and see if the problem goes
away.