Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
"deselect ?" a range or change state from edit to ?
i have a set of subs that process when a cell is double clicked; they open a
window with information about the contents of the cell the problem is: when i close the window, the target cell is in an edit (?) state (the vertical edit bar is visible within the text), then when the user clicks (selects) a different cell (there may be no need for them to edit the text in the target cell), the curser "bounces" back to the target cell putting it ina selected, but not edit state (?? ...i think this is what is happening ??) from this point on, a different cell can be selected and the selection will "stick" .... frustrating! i would like the target cell to remain selected when the window is closed (so the user knows where they were, but not in the edit state (so that when the user clicks a different cell, they remain with that new choice) thanks in advance, mark |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
why do i "sometimes" need to "edit chart object" before "source da | Charts and Charting in Excel | |||
change "true" and "false" to "availble" and "out of stock" | Excel Worksheet Functions | |||
Allow user to change the state of ("click" in) check-boxes on protected worksheets? | Excel Worksheet Functions | |||
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F | Excel Discussion (Misc queries) | |||
Incompatible "allow users to edit range" in earlier Excel versions | Excel Discussion (Misc queries) |