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
 

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]+[PgDn] and [Ctrl]+[PgUp] 2
Moving among protected sheets 2
Ctrl+Home failure when sheet protected 1
How can I scroll down or up by an entire page? 2
Word 2007: keyboard shortcuts stop working in form-enabled .dotmfile 1
Excel display problem 3
2003/2007 Compatibility Issue - Hidden Sheets 4
Windows XP Shortcut Key Combinations 0

Top