ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   worksheet protection (https://www.excelbanter.com/excel-discussion-misc-queries/176063-worksheet-protection.html)

J. Sperry[_2_]

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)


All times are GMT +1. The time now is 09:57 PM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com