Triggering click event of a menu in vba
 

Sub tester3()
CommandBars.FindControl(ID:=2915).Execute
End Sub

Regards,
Tom Ogilvy

"Aparna Rege" wrote in message
...
Hi,

I want to trigger the code behind an Excel commandbar button through vba
code without user selecting the command. To be specific I want to bring up
the 'Pivot Table and PivotChart Wizard' (Data PivotTable and PivotChart
Report) programmatically.
Does anybody know how to do this?

Thanks in advance,
Aparna