Hi everyone. I'm using the M$ Office Web Component Pivot Table in an application and I'd really like to have a Custom right click popup menu. I can do this - but the default popup menu ALWAYS shows up as well. There is no Cancel parameter on mouse down,, the Click event arrives too late, and this is not a User form (it's the Pivot Table Component) or text box so there is no "Locked = True" or "Enabled = False" property to temporarily set, as Francesco Balena's book suggests to use as a work around.
Questions:
1. Does anyone know a reasonably straightforward way to stop a default Popup menu from showing up?
2. Failing that, if I can get the control ID, maybe I can alter it as you would a regular menu, or stop it that way. Anyone have any ideas on how to do that?
4. Do I need to resort to an API?
5. Anyone know any good resources on Office Web Components. The only dedicated book I could find was for Office 2000 - not XP, and most of the Amazon reviewers complained that it was more for users than programmers. Micorosoft's website is of course more of a hit and miss suggestion box - no comprehensive examples on how to respond to user events, etc.
Any constructive comments or ideas would be greatly appreciated. Thanks!
Questions:
1. Does anyone know a reasonably straightforward way to stop a default Popup menu from showing up?
2. Failing that, if I can get the control ID, maybe I can alter it as you would a regular menu, or stop it that way. Anyone have any ideas on how to do that?
4. Do I need to resort to an API?
5. Anyone know any good resources on Office Web Components. The only dedicated book I could find was for Office 2000 - not XP, and most of the Amazon reviewers complained that it was more for users than programmers. Micorosoft's website is of course more of a hit and miss suggestion box - no comprehensive examples on how to respond to user events, etc.
Any constructive comments or ideas would be greatly appreciated. Thanks!