add button on pivot chart
 

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,

add button on pivot chart
 

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,

add button on pivot chart
 

Thanks millions,


"Andy Pope" wrote:

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,