Keyboard command different when protected

B

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
 
T

Tom Ogilvy

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

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
 
T

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.
 
Top