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
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Ctrl+PgUp and Ctrl+PgDn 2
[Ctrl]+[PgDn] and [Ctrl]+[PgUp] 2
Moving among protected sheets 2
Disabling Ctrl-PgUp and Ctrl-PgDn 3
Word 2000 - shortcuts Ctrl+ up/dn/pgup/pgdn don't work 5
Ctrl+Home failure when sheet protected 1
How can I scroll down or up by an entire page? 2
ctrl+home - Excel 2003 6

Back
Top