Excel: Ctrl+Page Up in Protected Worksheet

[RobTsintas]

Has anyone ever come across this problem, and is it a feature (with a specific reason) or a bug?

(Using Excel 2003). I like to use the Ctrl+Page Up and Ctrl+Page Down shortcuts to move between worksheets (in fact, I have assigned these to buttons on my mouse).

However, when I come to a protected sheet, the shortcuts don't work. Instead they do the same as Alt+Page Up/Down (scroll the view across by a whole screen).

This is very annoying, and I'd love to find a workaround. Does the same thing happen in other versions? I've tried searching for answers, but it's a difficult thing to search for.

Cheers

Rob

 

[AnotherHiggins]

I tried this on Excel 2003 SP2 and could not recreate your problem. I protected the sheet and used [Ctrl]+[Page Up] / [Ctrl]+[Page Down] with no problems.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.

 

[RobTsintas]

Maybe it was fixed in the service pack. Unfortunately it's on my work PC and I don't have any say in getting service packs applied!

Thanks for trying it out anyway.

I made my own workaround in VBA with a macro in my personal.xls. But I had to get it to skip any hidden sheets and stop at the first/last sheets, which made it a bit more complicated. Works fine though.

 

[AnotherHiggins]

I don't have a non-updated version of 2003 to play with, but I tried it with Excel 2000 and that also seemed to work just fine.

Weird.

[tt]_____
[blue]-John[/blue][/tt]
[tab][red]The plural of anecdote is not data[/red]

Help us help you. Please read FAQ 181-2886 before posting.