Logo 
Search:

MS Office Answers

Ask Question   UnAnswered
Home » Forum » MS Office       RSS Feeds
  Question Asked By: Alex Meyer   on Dec 18 In MS Office Category.

  
Question Answered By: Xander Thompson   on Dec 18

Thanks again for your ideas, all of them. For me at least, it
always helps to see things from another angle, even if I don't end up
using that particular code at the time.

The code I had used and posted in that earlier thread also includes
allowing the user  to click  on any column  with the same result. I do
think that the code you offered is a bit tighter and easier to use for
the column locations, though, so I'm still a couple of steps
better-off with your suggestions.

I'm thinking that it might be good  to try the BeforeDoubleClick
event, but as you said having too many events firing could be a
problem. After I test it, and if I get some workable code going, I'll
post it here.

I WAS curious however--if you avoid the SelectionChange event,
what other ways would you use? I understood your point and the logic
of it, just didn't know what other alternatives might be there that I
haven't seen thus far.

Again, thanks for your suggestions, and I hope this message  gets
thru since there's a winter storm going great guns here at the moment.

Share: 

 

This Question has 6 more answer(s). View Complete Question Thread

 
Didn't find what you were looking for? Find more on possible to change Protected Sheet error message? Or get search suggestion and latest updates.


Tagged: