Keyboard command different when protected

[bw]

<ctrl>PageDown moves to the next sheet in a workbook. But when the sheet
is protected, <ctrl>PageDown moves right to the next columns not
previously visible.

Is there someway to make <ctrl>PageDown work the way it is advertised
without un-protecting the worksheet?

Thanks,
Bernie

 

[Tom Ogilvy]

I couldn't reproduce the behavior you describe. Are you sure your scroll
lock key isn't on.

 

[bw]

Thanks for the reply, Tom.

Since you couldn't reproduce the problem, I did a little testing. When
you protect the sheet, the problem occurs when you check "Select unlocked
cells" AND do Not check "Select locked cells".

Bernie

 

[Tom Ogilvy]

It seems to be only with that setting. With either of the other two options
it works as expected.

Can't say that there is a way to change that behavior.