Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Up and Down Arrows do not work | Excel Discussion (Misc queries) | |||
EXCEL & WORK LOCKED | Excel Worksheet Functions | |||
how do I create a locked form to fill in the blanks | Excel Discussion (Misc queries) | |||
1 normal form | Excel Programming | |||
Format() doesn't work from a Form | Excel Programming |