Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
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 |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
My arrow keys move the spread sheet insted moving between cells | Setting up and Configuration of Excel | |||
protected sheet arrow keys not working on unlocked cells | Excel Discussion (Misc queries) | |||
Arrow keys moves the sheet, not the marker! | Excel Discussion (Misc queries) | |||
when I protect my sheet enter tab, & arrow keys dont work... | Excel Discussion (Misc queries) | |||
I can't navigate my sheet with my arrow keys. suggestions? | Excel Discussion (Misc queries) |