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: 441
Default Locked form: {End} key with arrows doesn't work as normal

I am using Office 2003 on Windows XP.

I have designed some forms in an Excel sheet using borders, cell shading,
etc.
There are also certain cells containing formulas that should not be changed,
so those cells are protected. Also, protection is set to only allow users to
select unprotected cells.

It all works fine, but when protection is on and users try to use the {End}
key in conjunction with one of the arrow keys to move the cell pointer around
in the form, it doesn't work as normal. Pressing {End} moves the cell pointer
to the last cell (rather than just turning on the {End} function). Then when
you use an arrow key, the cell pointer only moves one cell. This is very
annoying to some users.

My question is, is there a work around to this or do these users just need
to live with it?

Your suggestions are appreciated. Thanks in advance.
 
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
Up and Down Arrows do not work Josh C Excel Discussion (Misc queries) 2 April 2nd 09 07:54 PM
EXCEL & WORK LOCKED FLAWLESS Excel Worksheet Functions 9 November 9th 08 11:25 PM
how do I create a locked form to fill in the blanks bill Excel Discussion (Misc queries) 1 November 2nd 08 05:06 AM
1 normal form swchee Excel Programming 1 June 14th 05 11:40 PM
Format() doesn't work from a Form Chad Excel Programming 4 November 11th 04 04:56 PM


All times are GMT +1. The time now is 11:03 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"