| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
|
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| keyboard shortcut to move between protected worksheets | Excel Worksheet Functions | |||
| Keyboard command | Excel Worksheet Functions | |||
| Is there a keyboard command to switch between tabs in Excel? | Excel Discussion (Misc queries) | |||
| Keyboard Command to go to next blank cell | Excel Discussion (Misc queries) | |||
| Use Keyboard with Command Button | Excel Programming | |||
Linear Mode
