This is a follow up to previous question. Any ideas anyone?

Open a new workbook and protect all three of the default sheets. NOTE: be
sure to check only "Select Unlocked Cells" in the "Allow all users of this
worksheet to" dialogue box. Make sure "Select locked cells" is unchecked.

After the sheets are proteced this way it disables the ability to use the
keyboard shortcut "Control+Page-Down" to work.

Just wondering if anyone has found a fix for this.

Thank you.

Hi Joe,

In my spreadsheet it did not disable the command Ctrl+PgDn instead it
changed its action to the same as Alt+PgDn. This certainly seems like a bug
to me. There is no other keyboard shortcut which duplicates this command to
the best of my knowledge.


--
Thanks,
Shane Devenshire


"Joe" wrote:

This is a follow up to previous question. Any ideas anyone?

Open a new workbook and protect all three of the default sheets. NOTE: be
sure to check only "Select Unlocked Cells" in the "Allow all users of this
worksheet to" dialogue box. Make sure "Select locked cells" is unchecked.

After the sheets are proteced this way it disables the ability to use the
keyboard shortcut "Control+Page-Down" to work.

Just wondering if anyone has found a fix for this.

Thank you.