![]() |
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 |
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 |
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. |
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