Switch between protected worksheet by CTRL-PgDown
 

Hello,

I need help. Before I protected my worksheets, I could sweetch between them
using keybord by pressing CTRL-PgUo/CTRL-PgDown. Once I protecded Worksheets,
I couldnot do it any more. This function did not work. When I unprotect them
again, everything works again. I need to use keybord, but I need to protect
Worksheets, also.
Help?

This is a bug that was reported last week. As this is quite high in
usability, I would expect a patch in the next few weeks (Nothing guaranteed
of course ;-))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dusan Grubor" <Dusan wrote in message
...
Hello,

I need help. Before I protected my worksheets, I could sweetch between
them
using keybord by pressing CTRL-PgUo/CTRL-PgDown. Once I protecded
Worksheets,
I couldnot do it any more. This function did not work. When I unprotect
them
again, everything works again. I need to use keybord, but I need to
protect
Worksheets, also.
Help?

Which versions Nick?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nick Hodge" wrote in message
...
This is a bug that was reported last week. As this is quite high in
usability, I would expect a patch in the next few weeks (Nothing
guaranteed
of course ;-))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dusan Grubor" <Dusan wrote in message
...
Hello,

I need help. Before I protected my worksheets, I could sweetch between
them
using keybord by pressing CTRL-PgUo/CTRL-PgDown. Once I protecded
Worksheets,
I couldnot do it any more. This function did not work. When I unprotect
them
again, everything works again. I need to use keybord, but I need to
protect
Worksheets, also.
Help?

RD

Versions 2002 and 2003.

If you protect a worksheet and de-select "allow users to select locked cells"

the CTRL + PgUp and PgDn just move the cursor within that worksheet.

Reported by Harlan last week.

**************************

I've involuntarily upgraded to Excel 2002/XP. It has lots of lovely
security settings when protecting worksheets. When I _UN_check 'Select
locked cells' when protecting worksheets, the [Ctrl]+[PgDn] and
[Ctrl]+[PgUp] key combinations then function no differently than
[Alt]+[PgDn] and [Alt]+[PgUp] (so the same as they did back in Excel 4
and prior), paging right and left within the protected worksheet rather
than moving between worksheets.

If this isn't a bug, I don't know the meaning of the term. Has anyone
else come across it? There's no mention of it when searching *excel*
newsgroups in Google Groups for Ctrl and PgDn or Page Down or searching
in Microsoft's KB under Excel 2002 for these terms.

************************************


Gord Dibben Excel MVP

On Sun, 10 Apr 2005 07:40:05 -0700, "Ragdyer" wrote:

Which versions Nick?

XP & 2003 where you de-select the 'Select Locked Cells' option in the new
protection dialog. This leaves you unable to use PgUp, PgDown (I believe
discovered by Harlan Grove) code to test it (Courtesy Harlan or Ron de
Bruin, not sure which)

Private Sub Workbook_Open()
Dim Sh As Worksheet
Application.ScreenUpdating = False
For Each Sh In ThisWorkbook.Worksheets
Sh.Select
Sh.Protect userinterfaceonly:=True
Sh.EnableSelection = xlUnlockedCells
Next
Sheets(1).Select
Application.ScreenUpdating = True
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ragdyer" wrote in message
...
Which versions Nick?
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nick Hodge" wrote in message
...
This is a bug that was reported last week. As this is quite high in
usability, I would expect a patch in the next few weeks (Nothing
guaranteed
of course ;-))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dusan Grubor" <Dusan wrote in message
...
Hello,

I need help. Before I protected my worksheets, I could sweetch between
them
using keybord by pressing CTRL-PgUo/CTRL-PgDown. Once I protecded
Worksheets,
I couldnot do it any more. This function did not work. When I unprotect
them
again, everything works again. I need to use keybord, but I need to
protect
Worksheets, also.
Help?

Thanks guys,

The only machines I have access to on the weekends *don"t* exhibit this!
--
Regards,

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------
"Nick Hodge" wrote in message
...
XP & 2003 where you de-select the 'Select Locked Cells' option in the new
protection dialog. This leaves you unable to use PgUp, PgDown (I believe
discovered by Harlan Grove) code to test it (Courtesy Harlan or Ron de
Bruin, not sure which)

Private Sub Workbook_Open()
Dim Sh As Worksheet
Application.ScreenUpdating = False
For Each Sh In ThisWorkbook.Worksheets
Sh.Select
Sh.Protect userinterfaceonly:=True
Sh.EnableSelection = xlUnlockedCells
Next
Sheets(1).Select
Application.ScreenUpdating = True
End Sub


--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Ragdyer" wrote in message
...
Which versions Nick?
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-
"Nick Hodge" wrote in message
...
This is a bug that was reported last week. As this is quite high in
usability, I would expect a patch in the next few weeks (Nothing
guaranteed
of course ;-))

--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
HIS


"Dusan Grubor" <Dusan wrote in
message
...
Hello,

I need help. Before I protected my worksheets, I could sweetch
between
them
using keybord by pressing CTRL-PgUo/CTRL-PgDown. Once I protecded
Worksheets,
I couldnot do it any more. This function did not work. When I
unprotect
them
again, everything works again. I need to use keybord, but I need to
protect
Worksheets, also.
Help?