Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.setup
|
|||
|
|||
Moving among protected sheets
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? |
#2
Posted to microsoft.public.excel.misc,microsoft.public.excel.setup,microsoft.public.excel
|
|||
|
|||
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? |
#3
Posted to microsoft.public.excel,microsoft.public.excel.misc,microsoft.public.excel.setup
|
|||
|
|||
Moving among protected sheets
I don't know if this still works if the sheets are protected, but if
you right-click in the area where the sheet navigation buttons are located (bottom left) you will get a list of up to 16 sheet names (plus "more" if necessary) and you can move to a sheet by clicking its name - you can easily check if this facility is still available to you with protected worksheets. Hope this helps. Pete |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Protected power calculation spread sheets | Excel Discussion (Misc queries) | |||
navigational keys in protected sheets | Excel Discussion (Misc queries) | |||
Index of protected sheets | Excel Worksheet Functions | |||
grouping of cells in protected sheets | Excel Worksheet Functions | |||
Protected sheets | Excel Worksheet Functions |