View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.programming
Andy Pope Andy Pope is offline
external usenet poster
 
Posts: 2,489
Default Passing an event up the chain.

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?