View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel
John Crosher
 
Posts: n/a
Default Moving among protected sheets

I have tried on XL XP and [Ctrl] + [PgUp/PgDn] works OK for me, whether or
not any of the sheets are protected - also OK if sheet tabs are hidden. What
XL version are you on? You may have to reboot/re-install XL, as it could be
corrupt.

"Conan Kelly" wrote:

Hello all,

It appears that I can not use the [Ctrl] + [PgUp/PgDn] to move from a protected sheet. Can anyone verify this?

When I try the [Ctrl] + [PgUp/PgDn] key combo on a protected sheet, it acts like [Alt] + [PgUp/PgDn]: The worksheet scrolls
left/right one page at a time.

What if I do not have my sheet tabs showing? How do I move to other sheets (keyboard or mouse) when the sheet is protected and
sheet tabs are not shown?