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

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