ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Programming (https://www.excelbanter.com/excel-programming/)
-   -   Keyboard command different when protected (https://www.excelbanter.com/excel-programming/308896-keyboard-command-different-when-protected.html)

bw

Keyboard command different when protected
 
<ctrlPageDown moves to the next sheet in a workbook. But when the sheet
is protected, <ctrlPageDown moves right to the next columns not
previously visible.

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

Thanks,
Bernie

Tom Ogilvy

Keyboard command different when protected
 
I couldn't reproduce the behavior you describe. Are you sure your scroll
lock key isn't on.

--
Regards,
Tom Ogilvy


"bw" wrote in message news:opsdq1elp6vzdmg1@bw...
<ctrlPageDown moves to the next sheet in a workbook. But when the sheet
is protected, <ctrlPageDown moves right to the next columns not
previously visible.

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

Thanks,
Bernie




bw

Keyboard command different when protected
 
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

On Fri, 3 Sep 2004 09:13:11 -0400, Tom Ogilvy wrote:

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



Tom Ogilvy

Keyboard command different when protected
 
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.

--
Regards,
Tom Ogilvy

"bw" wrote in message news:opsdq9ea1gvzdmg1@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

On Fri, 3 Sep 2004 09:13:11 -0400, Tom Ogilvy wrote:

I couldn't reproduce the behavior you describe. Are you sure your

scroll
lock key isn't on.






All times are GMT +1. The time now is 05:21 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com