How to start a macro with pivot-chart-update-button (!)

[Snoopy]

Hey Guys
The pivot-chart-update-button (!) dominates my custom pivot-chart-
layout. This annoys me (and I get no credit from my colleges as Excel-
expert). The chart is placed in a chart-sheet.

I have recorded a macro that "re-build" the chart layout. But this
macro is to be activated only from the macro-list options, since Excel
not alows me to place an button in this chartsheet, and connect this
button to a macro which 1) updates the chart and 2) then re-build the
layout.

I hope for some qualified help here - to improve my repurtation in
this office - and make the stars shine on me... as long as it may
last.

best Regards
Snoopy

 

[Debra Dalgleish]

layout. This annoys me (and I get no credit from my colleges as Excel-
expert). The chart is placed in a chart-sheet.

I have recorded a macro that "re-build" the chart layout. But this
macro is to be activated only from the macro-list options, since Excel
not alows me to place an button in this chartsheet, and connect this
button to a macro which 1) updates the chart and 2) then re-build the
layout.

 

[Snoopy]

Thanks Debra
The pivot -(gremlin)-chart will still rebuild itself by every new
seclection.
Are there any options to preserve the chart-format when updating the
chart?

Best regards
Snoopy

 

[Debra Dalgleish]

You can record the steps as you reformat the pivot chart, then add that
code to your macro.

 

[Snoopy]

You can record the steps as you reformat the pivot chart, then add that
code to your macro.





Snoopywrote:



--
Debra Dalgleish
Contextureshttp://www.contextures.com/tiptech.html- Skjul sitert tekst -

- Vis sitert tekst -

Thanks ....
Hmmmmmm