Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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? |
#2
|
|||
|
|||
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? |
#3
|
|||
|
|||
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? |
#4
|
|||
|
|||
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? |
#6
|
|||
|
|||
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? |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Question about sorting in protected worksheet | Excel Worksheet Functions | |||
How to change the tab order for a protected worksheet | Excel Worksheet Functions | |||
How do i delete a row in a excel worksheet that is protected | Excel Worksheet Functions | |||
Protected Worksheet | New Users to Excel | |||
How use group and ungroup functions while worksheet is protected | Excel Worksheet Functions |