Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
jk
 
Posts: n/a
Default 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!
  #2   Report Post  
Posted to microsoft.public.excel.misc
Carboot
 
Posts: n/a
Default 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

Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
VBA code error with Protection turned on - help please Fred Excel Discussion (Misc queries) 1 March 17th 06 04:06 PM
An FAQ that never seems to be answered: autofiltering with protection on... JLC Excel Worksheet Functions 1 December 7th 05 06:14 AM
Illinois Personal Information Protection Act [email protected] Excel Worksheet Functions 0 August 16th 05 03:15 AM
workbook protection John New Users to Excel 1 January 22nd 05 12:55 PM
protection on excel forms cben Excel Worksheet Functions 1 December 14th 04 02:23 PM


All times are GMT +1. The time now is 07:57 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"