ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   Trouble with Cell/Worksheet Protection... (https://www.excelbanter.com/excel-discussion-misc-queries/63543-trouble-cell-worksheet-protection.html)

jk

Trouble with Cell/Worksheet Protection...
 
I have a file with an input sheet where all cells are protected except for
the few that require user input. When I am in this input sheet, the
<CTRL-Page-Down(and Up) keys do not work properly. Instead of moving to the
next worksheet it scrolls to the right (or left) in the input sheet. Is this
problem due to the cell protection in this sheet (it works properly in other
sheets that are not protected in the same file)? If so, is there a way to
correct this?

Thanks!

Carboot

Trouble with Cell/Worksheet Protection...
 

Check the settings on the Tools/Options/Transitions tab. If they are set
on it can affect the normal Excel move around keys.


--
Carboot
------------------------------------------------------------------------
Carboot's Profile: http://www.excelforum.com/member.php...o&userid=18076
View this thread: http://www.excelforum.com/showthread...hreadid=498771



All times are GMT +1. The time now is 10:41 AM.

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