Shortcut CTRL - PAGE UP/ DOWN won't work on protected sheets

[AA Arens]

CTRL-PAGE UP / DOWN is to move from one sheet to another.
Unfortunately it doesn't help after I entered a protected sheet. There
is one case about this issue in Feb 2006.

http://groups.google.com/group/micr...=gst&q=shortcut+sheet&rnum=4#66d0dc65564364e8

I sounds that it is a bug on some PC's.

Anybody has a solution?

Bart

 

[shanedevenshire]

CTRL-PAGE UP / DOWN is to move from one sheet to another.
Unfortunately it doesn't help after I entered a protected sheet. There
is one case about this issue in Feb 2006.

http://groups.google.com/group/microsoft.public.excel/browse_thread/t...

I sounds that it is a bug on some PC's.

Anybody has a solution?

Bart

What version of Excel are you using? What exactly is the protection
command you are using - Tools, Protection, Protect Sheet, all items
unchecked? And do you mean that you are able to move between all the
other sheets in the workbook using the shortcut key but not out of the
one that is protected?

Are there any macros in the file?

Cheers,
Shane

 

[Ron de Bruin]

Hi Bart / Shane

There is a bug when you have "select unlocked cells" selected in the protection dialog
The shortcut key is not working then

 

[AA Arens]

Hi Bart / Shane

There is a bug when you have "select unlocked cells" selected in the protection dialog
The shortcut key is not working then

Indeed I am trapped in the bug. Use Excell 2003/Only "Select Unlocked
Cells" is active.
I am able to jump freely when the sheets are unprotected or when the
toggle is off.

Bart