Double Click on cell to run Macro

Hi,

I am trying to run a macro when I double click on a certain cell (D34). The cell has data in it (Southeast NSC). What Im expecting to happen is once I double click on the cell the macro will run the retrieve and I will end up at expense chart page.

The macro I am trying to run is an Essbase retrieve.

Please Login or Register  to view this content.

I tried using the macro below but no luck:

Please Login or Register  to view this content.

and i tried:

Please Login or Register  to view this content.

Please Help

If the code for the sub Drill_Down is in a standard module this is all you should need to call it.

Please Login or Register  to view this content.

If want to check the cell that was double clicked is D34 them use this

Please Login or Register  to view this content.

So combined.

Please Login or Register  to view this content.

PS Can you use code tags when posting code?