Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets
Hi
Although CTRL+PGUP and CTRL+PGDN are valid keyboard shortcuts for moving through worksheets - they don't seem to work when the worksheet is Protected. Similarly, CTRL+HOME doesn't work. Is there is switch off of CTRL+ functions in a protected worksheet? Does anyone have any idea how to overcome this? Thanks Dave |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets
If you uncheck select locked cells when you protect the sheets you have this problem.
Same problem in older versions of Excel also -- Regards Ron de Bruin http://www.rondebruin.nl/tips.htm "DrDave" wrote in message ... Hi Although CTRL+PGUP and CTRL+PGDN are valid keyboard shortcuts for moving through worksheets - they don't seem to work when the worksheet is Protected. Similarly, CTRL+HOME doesn't work. Is there is switch off of CTRL+ functions in a protected worksheet? Does anyone have any idea how to overcome this? Thanks Dave |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
use CTRL key inside a macro IE CTRL + ; | Excel Worksheet Functions | |||
CTRL+select Excel 2007 | Excel Worksheet Functions | |||
Anyone having Ctrl+C / Ctrl+V problems in E2007? | Excel Discussion (Misc queries) | |||
ctrl + tab (first in, first out history) with excel sheets? | Excel Worksheet Functions | |||
Ctrl+pgup pgdn can't jump worksheets | Excel Worksheet Functions |