WOW, Dave - Thanks. That worked great!
I am quite familiar with VB for developing desktop applications, however this is the first time I have done anything with excel. Could you go into a little detail with the code on what is doing what?
Just for my personal knowledge - As in:
Application.Intersect
Cancel = True
rng = Target
Just hoping for a little clarification on what that is - but as far as the problem I was having...that absolutely fixed it.
Thank you so much!
Application.Intersect - determins the target range
Cancel = True - when you double click a cell, excel wants you to edit the cell, this stops that from happening.
rng = Target- we set rng to be range("M5"), when you double click a cell in the target range, M5 is equal to the cell double clicked..
There are currently 1 users browsing this thread. (0 members and 1 guests)
Posting Permissions
LinkBack URL
About LinkBacks
Register To Reply
,
Bookmarks