View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
J. Sperry[_2_] J. Sperry[_2_] is offline
external usenet poster
 
Posts: 33
Default worksheet protection

I turned on worksheet protection, with the "Select locked cells" option
unchecked. For some reason, the Control + PageUp/Down keyboard shorcut no
longer works as advertised. Instead of moving to the previous/next sheet, it
works like a horizontal scroll bar, changing the view of the current sheet,
while keeping the active cell unchanged. If I check the "Select locked
cells" option, the keyboard shortcut works like normal. Any ideas why this
happens?

(happens in both Excel 2003 and 2007)