keyboard shortcut to move between protected worksheets

J

Joe

The control-page up or control-page down keyboard shortcuts do not work when
the sheets are protected. How do you move from sheet to sheet within a
workbook without a mouse when the sheets are protected.
 
J

Joe

Sorry Mike,

I should have been more specific.

If you do the following you will see the problem:

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top