View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.programming
Darin Kramer Darin Kramer is offline
external usenet poster
 
Posts: 397
Default Pivot table to launch Macro

Howdie,

When a user makes a selection from the top left piece (Called the "page
Field" section) of the pivot table, it changes the contents of pivot
table (as per normal)

I am having spacing problems - ie I wrap text and then align top, set
column width of the contents of the pivot table, BUT when you change an
entry in the page field section it resets the format of the contents of
the piviot table. I have written a basic macro that fixes the content
of the table, but how do I tell Excel to run this macro each time the
pivot table changes?

Thanks

D


*** Sent via Developersdex http://www.developersdex.com ***