Switch between protected worksheet by CTRL-PgDown

[Guest]

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?

 

[Nick Hodge]

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
(e-mail address removed)

 

[Ragdyer]

Which versions Nick?

 

[Gord Dibben]

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

 

[Nick Hodge]

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
(e-mail address removed)

 

[Ragdyer]

Thanks guys,

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