View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Luke M Luke M is offline
external usenet poster
 
Posts: 2,722
Default Ctrl Home disabled in protected worksheets

When you protect the workbook, are you allowing users to select locked cells?
This would need to be enabled for Ctrl+Home to work, since A1 is locked.
--
Best Regards,

Luke M
*Remember to click "yes" if this post helped you!*


"Rod from B.C. Government" wrote:

I have created a workbook with a number of worksheets, each of which has a
number of locked cells and for which protection is enabled to prevent users
from accessing locked cells. The top row, with the column headings, is
protected.

I have noticed that the control + home function to go to cell A1 seems to be
disabled. How can I re-enable it? (I am running Excel 2003).