Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip to next input cell on protected worksheet
Is there a way of skipping to the next input cell, on a protected
worksheet, when the enter/return key is pressed ? I have a protected worksheet with a number of input cells. Because of the layout there are rows in between the input cells, so when enter/return is pressed the cell immediately below the current one is selected, instead, I would like to move to the next input cell at this point. Thanks and regards Fred |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip to next input cell on protected worksheet
if your using xl 2002 you can uncheck select lock cells in the protect
sheet option. "Fred" wrote in message oups.com... Is there a way of skipping to the next input cell, on a protected worksheet, when the enter/return key is pressed ? I have a protected worksheet with a number of input cells. Because of the layout there are rows in between the input cells, so when enter/return is pressed the cell immediately below the current one is selected, instead, I would like to move to the next input cell at this point. Thanks and regards Fred |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip to next input cell on protected worksheet
Hi Jon,
Sadly i'm a mere Excel/97 user. I aspire to 2000, but as for 2002, the air must be rarified indeed. Thanks for the pointer though, i'll store for future reference. Regards Fred |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip to next input cell on protected worksheet
Fred,
Unless I misunderstand, isn't this set in Options, whether Enter moves down, right or nowhere. Also, if you set the worksheet property .EnablesSelection to xlUnlockedCells, it should achieve your goal. That's XL2K, can't say about XL97. NickHK "Fred" egroups.com... Is there a way of skipping to the next input cell, on a protected worksheet, when the enter/return key is pressed ? I have a protected worksheet with a number of input cells. Because of the layout there are rows in between the input cells, so when enter/return is pressed the cell immediately below the current one is selected, instead, I would like to move to the next input cell at this point. Thanks and regards Fred |
#5
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip to next input cell on protected worksheet
Hi Nick, Not really. In Excel/97, the only options in the "Move selection after enter" are Up, Down, Left or Right. Whether the sheet is Protected or not, when enter is pressed the next cell (as selected in the Move Selection option) is selected. What I am after is for it to go to the next Unlocked cell, as per Format Cells, Protection. Using the TAB key, with the worksheet protected, the next Unlocked cell is selected. I have seen, and tried implementing a number of solutions, identified in this group, the one i'm missing at the moment is what to do if there is no change to the content of an input cell. I have coded up Worksheet_Change routine that works fine, as long as the cell content changes, but if unchanged, nothing happens. Cheers Fred |
#6
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip to next input cell on protected worksheet
If I understand you correctly (as I can't the earlier posts in this thread),
as well as protection, you need to set the worksheet property ..EnableSelection=1 (xlUnlockedCells). Either in code or from the properties sheet. I presume this is available in XL97. NickHK "Fred" wrote in message ups.com... Hi Nick, Not really. In Excel/97, the only options in the "Move selection after enter" are Up, Down, Left or Right. Whether the sheet is Protected or not, when enter is pressed the next cell (as selected in the Move Selection option) is selected. What I am after is for it to go to the next Unlocked cell, as per Format Cells, Protection. Using the TAB key, with the worksheet protected, the next Unlocked cell is selected. I have seen, and tried implementing a number of solutions, identified in this group, the one i'm missing at the moment is what to do if there is no change to the content of an input cell. I have coded up Worksheet_Change routine that works fine, as long as the cell content changes, but if unchanged, nothing happens. Cheers Fred |
#7
Posted to microsoft.public.excel.programming
|
|||
|
|||
Skip to next input cell on protected worksheet
Hi Nick
Perfect, that did just what I was after. Many thanks Fred |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Skip Copying a protected cell with subtotal | Excel Discussion (Misc queries) | |||
Can you paste to protected spreadsheet and skip over locked cells? | Excel Discussion (Misc queries) | |||
How do I dictate cell to cell progression in a protected worksheet | Excel Worksheet Functions | |||
Need to add cell comments in unlocked cell on protected worksheet | Excel Discussion (Misc queries) | |||
Why do cells skip around when I am trying to input figure within | Excel Discussion (Misc queries) |