View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Drew[_2_] Drew[_2_] is offline
external usenet poster
 
Posts: 22
Default Ctrl+Home failure when sheet protected

I have a problem that I cannot find solution for on any site . so .

I am using Excel 2007 and with XP2 fully up to date.

When I 'protect' a worksheet so only unlocked cells are accessable,
Ctrl+Home will not work, and neither will Ctrl+End. You can move to any of
the unlocked cells via enter, arrow keys or mouse and edit in them but
Ctrl+Home will not take you to the first unlocked cell.

Compounding this conundrum is the fact that the original master worksheet
that I used as the basis for the new master in the same workbook, works
fine. None of the worksheets copied using the second new master will allow
Ctrl+Home to work. Weird!!

Any thoughts on what or why would be appreciated?

Thank you.