Ctl Page Up and Ctl Page Down work selectively "Bob Flanagan" <nospam[ at ]nospam.net> 12/31/2008 1:36:04 PM I just received a workbook, and on the first sheet I can press Ctl page down and navigate to the next worksheet. However, on all the other sheets, this same action (or Ctl page up) does not change sheets, but shifts me left or right, like I had clicked on the horizontal scroll bar. I have examined all the settings in Tools, Options (using excel 2003), but do not see anything different between the sheets. New sheets act normal - I can shift from one new sheet to the other via key strokes. The sheets which do not work normal have had their sheet tabs colored and contain () in the names as they are copied sheets. Removing the color and renaming does not solve. Copying to a new workbook does not solve. There are no hidden or very hidden sheets in the workbook. The workbook and sheets are not protected. There are no macros in the workbook Any ideas? Bob

Re: Ctl Page Up and Ctl Page Down work selectively Andy Pope <andy[ at ]andypope.info> 12/31/2008 2:55:43 PM Hi Bob, CTRL+Page not working is normally caused by the worksheet having been protected and only unlocked cells being selectable. I know you said the sheets were not protected but have you checked the setting via Tools > Protection. As some cells will be editable. What version of xl are you using? Cheers Andy Bob Flanagan wrote: [Quoted Text] > I just received a workbook, and on the first sheet I can press Ctl page down > and navigate to the next worksheet. However, on all the other sheets, this > same action (or Ctl page up) does not change sheets, but shifts me left or > right, like I had clicked on the horizontal scroll bar. > > I have examined all the settings in Tools, Options (using excel 2003), but > do not see anything different between the sheets. New sheets act normal - I > can shift from one new sheet to the other via key strokes. > > The sheets which do not work normal have had their sheet tabs colored and > contain () in the names as they are copied sheets. Removing the color and > renaming does not solve. > > Copying to a new workbook does not solve. > > There are no hidden or very hidden sheets in the workbook. > > The workbook and sheets are not protected. > > There are no macros in the workbook > > Any ideas? > > Bob > > -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info

Re: Ctl Page Up and Ctl Page Down work selectively "Bob Flanagan" <nospam[ at ]nospam.net> 12/31/2008 4:31:30 PM Andy, that was it. I had assumed the sheet was unprotected as I could modify cells. Why would the protection status of a sheet change how ctl-pageup and down work? Is this a feature or a bug? Looks like a bug.... Bob "Andy Pope" <andy[ at ]andypope.info> wrote in message news:OIrfcf1aJHA.4276[ at ]TK2MSFTNGP05.phx.gbl... [Quoted Text] > Hi Bob, > > CTRL+Page not working is normally caused by the worksheet having been > protected and only unlocked cells being selectable. > I know you said the sheets were not protected but have you checked the > setting via Tools > Protection. As some cells will be editable. > > What version of xl are you using? > > Cheers > Andy > > > > Bob Flanagan wrote: >> I just received a workbook, and on the first sheet I can press Ctl page >> down and navigate to the next worksheet. However, on all the other >> sheets, this same action (or Ctl page up) does not change sheets, but >> shifts me left or right, like I had clicked on the horizontal scroll bar. >> >> I have examined all the settings in Tools, Options (using excel 2003), >> but do not see anything different between the sheets. New sheets act >> normal - I can shift from one new sheet to the other via key strokes. >> >> The sheets which do not work normal have had their sheet tabs colored and >> contain () in the names as they are copied sheets. Removing the color >> and renaming does not solve. >> >> Copying to a new workbook does not solve. >> >> There are no hidden or very hidden sheets in the workbook. >> >> The workbook and sheets are not protected. >> >> There are no macros in the workbook >> >> Any ideas? >> >> Bob > > -- > > Andy Pope, Microsoft MVP - Excel > http://www.andypope.info

Re: Ctl Page Up and Ctl Page Down work selectively Andy Pope <andy[ at ]andypope.info> 12/31/2008 4:58:30 PM A bug rather than a feature. Although I can not locate any pages detailing the problem. Cheers Andy Bob Flanagan wrote: [Quoted Text] > Andy, that was it. I had assumed the sheet was unprotected as I could > modify cells. > > Why would the protection status of a sheet change how ctl-pageup and down > work? Is this a feature or a bug? Looks like a bug.... > > Bob > > "Andy Pope" <andy[ at ]andypope.info> wrote in message > news:OIrfcf1aJHA.4276[ at ]TK2MSFTNGP05.phx.gbl... > >>Hi Bob, >> >>CTRL+Page not working is normally caused by the worksheet having been >>protected and only unlocked cells being selectable. >>I know you said the sheets were not protected but have you checked the >>setting via Tools > Protection. As some cells will be editable. >> >>What version of xl are you using? >> >>Cheers >>Andy >> >> >> >>Bob Flanagan wrote: >> >>>I just received a workbook, and on the first sheet I can press Ctl page >>>down and navigate to the next worksheet. However, on all the other >>>sheets, this same action (or Ctl page up) does not change sheets, but >>>shifts me left or right, like I had clicked on the horizontal scroll bar. >>> >>>I have examined all the settings in Tools, Options (using excel 2003), >>>but do not see anything different between the sheets. New sheets act >>>normal - I can shift from one new sheet to the other via key strokes. >>> >>>The sheets which do not work normal have had their sheet tabs colored and >>>contain () in the names as they are copied sheets. Removing the color >>>and renaming does not solve. >>> >>>Copying to a new workbook does not solve. >>> >>>There are no hidden or very hidden sheets in the workbook. >>> >>>The workbook and sheets are not protected. >>> >>>There are no macros in the workbook >>> >>>Any ideas? >>> >>>Bob >> >>-- >> >>Andy Pope, Microsoft MVP - Excel >>http://www.andypope.info > > > -- Andy Pope, Microsoft MVP - Excel http://www.andypope.info

Re: Ctl Page Up and Ctl Page Down work selectively "Ron de Bruin" <rondebruin[ at ]kabelfoon.nl> 12/31/2008 5:07:55 PM Hi Old bug that I report a few times in betas, I not think it will be fixed. -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "Andy Pope" <andy[ at ]andypope.info> wrote in message news:%2332iDk2aJHA.4660[ at ]TK2MSFTNGP04.phx.gbl... [Quoted Text] >A bug rather than a feature. > Although I can not locate any pages detailing the problem. > > Cheers > Andy > > Bob Flanagan wrote: >> Andy, that was it. I had assumed the sheet was unprotected as I could >> modify cells. >> >> Why would the protection status of a sheet change how ctl-pageup and down >> work? Is this a feature or a bug? Looks like a bug.... >> >> Bob >> >> "Andy Pope" <andy[ at ]andypope.info> wrote in message >> news:OIrfcf1aJHA.4276[ at ]TK2MSFTNGP05.phx.gbl... >> >>>Hi Bob, >>> >>>CTRL+Page not working is normally caused by the worksheet having been >>>protected and only unlocked cells being selectable. >>>I know you said the sheets were not protected but have you checked the >>>setting via Tools > Protection. As some cells will be editable. >>> >>>What version of xl are you using? >>> >>>Cheers >>>Andy >>> >>> >>> >>>Bob Flanagan wrote: >>> >>>>I just received a workbook, and on the first sheet I can press Ctl page >>>>down and navigate to the next worksheet. However, on all the other >>>>sheets, this same action (or Ctl page up) does not change sheets, but >>>>shifts me left or right, like I had clicked on the horizontal scroll bar. >>>> >>>>I have examined all the settings in Tools, Options (using excel 2003), >>>>but do not see anything different between the sheets. New sheets act >>>>normal - I can shift from one new sheet to the other via key strokes. >>>> >>>>The sheets which do not work normal have had their sheet tabs colored and >>>>contain () in the names as they are copied sheets. Removing the color >>>>and renaming does not solve. >>>> >>>>Copying to a new workbook does not solve. >>>> >>>>There are no hidden or very hidden sheets in the workbook. >>>> >>>>The workbook and sheets are not protected. >>>> >>>>There are no macros in the workbook >>>> >>>>Any ideas? >>>> >>>>Bob >>> >>>-- >>> >>>Andy Pope, Microsoft MVP - Excel >>>http://www.andypope.info >> >> >> > > -- > > Andy Pope, Microsoft MVP - Excel > http://www.andypope.info