View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Joe Joe is offline
external usenet poster
 
Posts: 476
Default Moving between sheets in Excel w/o keyboard

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.