add button on pivot chart

[Souris]

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,

 

[Andy Pope]

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

 

[Souris]

Thanks millions,

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