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.