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

  • Thread starter Thread starter DrDave
  • Start date Start date
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
 
If you uncheck select locked cells when you protect the sheets you have this problem.
Same problem in older versions of Excel also
 
Back
Top