Macro to simulate a basic double click on a cell

Welcome to the MrExcel board!

I must be mis-understanding because it seems you are saying that you have double-click event code but when you double-click a cell you don't want the double-click code to run.

Yep. I have doubleclick code that does some formatting and adding data to cells. But in order to make it so that it only works on the workbooks that need it and not on other workbooks the user may be working on, I also have it so that the user toggles it on and off. when it is toggled on and the user switches to another workbook, they lose the basic double click to go into editing the cell. As a work around, I have it so that the first double click on another workbook toggles my doubleclick code off and then things work fine. But, ultimately, I would like the user to be able to keep the double click toggle on, move to other workbooks and still have their normally double click use.

I just need to know if there is a way to put a the activecell into that edit mode using VBA.

Thanks!

Did you use?
lenze

Perhaps putting this line into your sub will have the desired effect:

SendKeys "{F2}"

What am I missing here? Double-click code would normally be stored in the worksheet or workbook module of the sheet/book that it is to apply to. So if you have certain workbooks that you don't want it to apply to, just don't put the code in those workbooks.

winxpdows said:

I just need to know if there is a way to put a the activecell into that edit mode using VBA.

Click to expand...

As a matter of interest, that was my very first question when I joined the forum.
http://www.mrexcel.com/forum/showthread.php?t=143560

Thanks! That worked. I totally forgot about F2.

Peter_SSs... If I had seen your first post, that would have solved everything. =) I had searched terms like double click and couldn't find anything. The reason why the double click code isn't in the specific workbook is because I made it an add-in in case the user has multiple workbooks that need the new functionality.. Thanks again!