Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.programming
|
|||
|
|||
![]()
On May 5th I wrote a question about how to launch an Excel Macro by double
clicking on a cell. I have tried what was suggested, but I still cannot make it work. Any further help would be greatly appreciated. I have the following code in the "View Code" area of the worksheet. Sub aaa() Application.Events = True End Sub Private Sub Worksheet_BeforeDoubleClick_(ByVal Target As Range, Cancel As Boolean) If Target.Address = $E$5 Then Cancel=True Call Find2 End IF End Sub Macros are enabled. When I double click on E5 in the worksheet that I put the code into, nothing happens, except the cell E5 is selected. I have a button on the same sheet that runs Macro Find2 when clicked. I am running Windows XP, Excel OFFXL7 Thank-you Jim Walsh |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Launching a Macro bt Double Clicking | Excel Programming | |||
Launch an excel hyperlink programatically without clicking | Excel Programming | |||
How can I use VB code to execute macro when double-clicking cell? | Excel Programming | |||
Launching a macro by double-clicking on active cell | Excel Programming | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming |