I have a front end with 4 embedded pivot charts. Each chart has macros take
the user to select different categories, then go into the table of the pivot
report. However, when to do, the macro buttons are resized because the chart
changes and is resized. In addition, when they select a category, the chart
title pops up, and also moves the pivot table buttons.
I tried adding protection, but all that did is stop the macros from working.

Is there any way to maintain the button formatting when the pivot chart data
changes. Thanks.

Hi,

What version of Excel are you using? Are the buttons ones you have added or
field buttons? If your own buttons, where are they, on the chart or in the
spreadsheet? Also, you say the chart resizes? do you mean the plot area
resizes?

--
Thanks,
Shane Devenshire


"jackie" wrote:

I have a front end with 4 embedded pivot charts. Each chart has macros take
the user to select different categories, then go into the table of the pivot
report. However, when to do, the macro buttons are resized because the chart
changes and is resized. In addition, when they select a category, the chart
title pops up, and also moves the pivot table buttons.
I tried adding protection, but all that did is stop the macros from working.

Is there any way to maintain the button formatting when the pivot chart data
changes. Thanks.