Hi,
Have a read here.
http://www.mvps.org/dmcritchie/excel/rightclick.htm
Cheers
Andy
--
Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"andy the pugh" wrote in message
...
On Jun 2, 4:59 pm, "Andy Pope" wrote:
I was able to get this to work, as there is no direct event.
Aha! Clever stuff. Thanks for that, I think I will use that instead of
the rather untidy Chart_MouseMove bodge I came up with.
However, thinking about this some more, I think I still need a context
menu for altering the Z scale (and a few other configurations). Could
you give any pointers on how to do that? Do I need to create a
msoPopup in the Application.Commandbars collection? That sounds rather
tricksy. Or can I create a Userform in a Popup style?