LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 230
Default Arrow Keys disabled after Sheet Protection

Here's something wierd, Excel 2003. I highlighted some columns and from
Format Cells Protection tab unchecked the Locked checkbox, so these columns
would be editable even after protecting the worksheet.

I then turned on protection and unchecked the box that says "Select locked
cells". Basically, my intention is to block users from selecting cells
outside of the columns I highlighted. So far so good, and it works well to
lock out people from entering those cells or reading the formulas (except
through code). Here's what's wierd though: No matter where in the unlocked
region I click, the down and up arrow keys are disabled. They take me to row
1 and just cycle through unlocked cells there. This is gonna tick off the
user more than just locking them out of certain columns, I can bet that
much.

Bill


 
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
My arrow keys move the spread sheet insted moving between cells Xboxy Setting up and Configuration of Excel 1 July 29th 08 02:34 AM
protected sheet arrow keys not working on unlocked cells JVFRAN Excel Discussion (Misc queries) 0 October 16th 06 07:17 PM
Arrow keys moves the sheet, not the marker! [email protected] Excel Discussion (Misc queries) 3 December 15th 05 09:12 AM
when I protect my sheet enter tab, & arrow keys dont work... greg Excel Discussion (Misc queries) 0 May 25th 05 03:30 PM
I can't navigate my sheet with my arrow keys. suggestions? Mark Excel Discussion (Misc queries) 1 May 2nd 05 08:45 PM


All times are GMT +1. The time now is 02:58 PM.

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

About Us

"It's about Microsoft Excel"