"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 |
All times are GMT +1. The time now is 12:59 PM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com