I have a very simple piece of code to simulate doubleclick which I have
assigned to a macro.
The macro is available both through a keyboard shortcut and as a button on
the menu bar.
My problem arises when using a pivot tabe.
The keyboard shortcut will not work in the data area of the pivot table, but
the button on the menu bar works perfectly.

The code is simply applicatio.doubleclick

Does anyone have an idea how I can get the keyboard shortcut to execute the
macro in the same way as the button on the menu bar.

Thanks