Hi,

You can not use controls from the Control Toolbox on charts or chartobjects.
You have to use the Forms toolbar instead and assign a macro to the OnAction
property.

Cheers
Andy

--

Andy Pope, Microsoft MVP - Excel
http://www.andypope.info
"Souris" wrote in message
...
I would like to add a button on the pivot chart sheet, but control tool bar
disable all the controls.

Does pivot chart support to put controls on the sheet?


Your information is great appreciated,