Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrow Keys disabled after Sheet Protection
William,
I was able to reproduce what you say here, except that I found that the down arrow took me down to row 11 of the 3 columns I highlighted. If I clicked on a cell in an unlocked column below row 11, it took me back up to the top of the first column, just as you describe. I did a Google Groups search on "down arrow select locked cells group:*excel.programming*" and with some reading of old replies (Tom O and KeepItCool) here's what it seems is happening: the down arrow only cycles me through cells that are part of the usedrange plus 1 row. For example, the reason i was originally able to down arrow to row 11 was because i'd changed the backcolor down to row 10. When I colored cells down to row 20 i could then down arrow to row 21 in the unlocked columns. hth, Doug "William Benson" wrote in message ... 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrow Keys disabled after Sheet Protection
Abundant thanks for the research. Your helpful explanation puts it all at
least in a context that makes sense. I still think it's unnecessary change in arrow key behavior in some situations, but maybe it is helpful in others .... Thank you again Doug. Bill. "Doug Glancy" wrote in message ... William, I was able to reproduce what you say here, except that I found that the down arrow took me down to row 11 of the 3 columns I highlighted. If I clicked on a cell in an unlocked column below row 11, it took me back up to the top of the first column, just as you describe. I did a Google Groups search on "down arrow select locked cells group:*excel.programming*" and with some reading of old replies (Tom O and KeepItCool) here's what it seems is happening: the down arrow only cycles me through cells that are part of the usedrange plus 1 row. For example, the reason i was originally able to down arrow to row 11 was because i'd changed the backcolor down to row 10. When I colored cells down to row 20 i could then down arrow to row 21 in the unlocked columns. hth, Doug "William Benson" wrote in message ... 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 |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrow Keys disabled after Sheet Protection
Your welcome Bill,
I figure even the people who program Excel must sometimes just say, "this will have to do" when trying to program some feature and maybe this was one of them... Doug "William Benson" wrote in message ... Abundant thanks for the research. Your helpful explanation puts it all at least in a context that makes sense. I still think it's unnecessary change in arrow key behavior in some situations, but maybe it is helpful in others ... Thank you again Doug. Bill. "Doug Glancy" wrote in message ... William, I was able to reproduce what you say here, except that I found that the down arrow took me down to row 11 of the 3 columns I highlighted. If I clicked on a cell in an unlocked column below row 11, it took me back up to the top of the first column, just as you describe. I did a Google Groups search on "down arrow select locked cells group:*excel.programming*" and with some reading of old replies (Tom O and KeepItCool) here's what it seems is happening: the down arrow only cycles me through cells that are part of the usedrange plus 1 row. For example, the reason i was originally able to down arrow to row 11 was because i'd changed the backcolor down to row 10. When I colored cells down to row 20 i could then down arrow to row 21 in the unlocked columns. hth, Doug "William Benson" wrote in message ... 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 |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Arrow Keys disabled after Sheet Protection
The expanded Protection options are well worth it all...
"Doug Glancy" wrote in message ... Your welcome Bill, I figure even the people who program Excel must sometimes just say, "this will have to do" when trying to program some feature and maybe this was one of them... Doug "William Benson" wrote in message ... Abundant thanks for the research. Your helpful explanation puts it all at least in a context that makes sense. I still think it's unnecessary change in arrow key behavior in some situations, but maybe it is helpful in others ... Thank you again Doug. Bill. "Doug Glancy" wrote in message ... William, I was able to reproduce what you say here, except that I found that the down arrow took me down to row 11 of the 3 columns I highlighted. If I clicked on a cell in an unlocked column below row 11, it took me back up to the top of the first column, just as you describe. I did a Google Groups search on "down arrow select locked cells group:*excel.programming*" and with some reading of old replies (Tom O and KeepItCool) here's what it seems is happening: the down arrow only cycles me through cells that are part of the usedrange plus 1 row. For example, the reason i was originally able to down arrow to row 11 was because i'd changed the backcolor down to row 10. When I colored cells down to row 20 i could then down arrow to row 21 in the unlocked columns. hth, Doug "William Benson" wrote in message ... 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
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) |