Excel 2007: Ctrl+PgUp or Ctrl+PgDn with Protected Sheets

D

DrDave

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
 
R

Ron de Bruin

If you uncheck select locked cells when you protect the sheets you have this problem.
Same problem in older versions of Excel also
 
Top