Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.programming
external usenet poster
 
Posts: 89
Default "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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
why do i "sometimes" need to "edit chart object" before "source da Flirty and Blonde Charts and Charting in Excel 1 February 2nd 10 02:07 PM
change "true" and "false" to "availble" and "out of stock" inthestands Excel Worksheet Functions 2 July 19th 07 07:05 PM
Allow user to change the state of ("click" in) check-boxes on protected worksheets? Chuck Zissman Excel Worksheet Functions 2 May 12th 07 08:10 PM
Lost "File Menu" - now it's "Edit / View / Insert.." but no "F daves Excel Discussion (Misc queries) 3 April 24th 07 04:52 AM
Incompatible "allow users to edit range" in earlier Excel versions PKnott Excel Discussion (Misc queries) 1 June 17th 06 01:28 AM


All times are GMT +1. The time now is 01:28 AM.

Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"