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).
|