I have a Pivottable in Excel in VBA and I want to get rid of the menu that appears when i right-click... How will i proceed??:(
Printable View
I have a Pivottable in Excel in VBA and I want to get rid of the menu that appears when i right-click... How will i proceed??:(
Is you where using pure VB, I would have told you to sub-class the control, and thereby eliminate the right-click. But using VBA, which btw. is a very limited version of VB, you would properly need some sort of 3rd-party tool, and that might not even do it.
So unless that control has a build in property, that eliminates the right-click, I will say that: you will just have to live with the pop-up menu. Sorry.