Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
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 *** |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table to launch Macro
Darin,
have you tried right-clicking in the pivot table and un-ticking 'autoformat table'? it sounds as though this would do the same thing without the need for vba. Tim "Darin Kramer" wrote in message ... 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 *** |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table to launch Macro
Hi Tim,
I tried that - I also tried unchecking the "Preserve format" option - but did not work... *** Sent via Developersdex http://www.developersdex.com *** |
#4
Posted to microsoft.public.excel.programming
|
|||
|
|||
Pivot table to launch Macro
"Darin Kramer" wrote in message
... Hi Tim, I tried that - I also tried unchecking the "Preserve format" option - but did not work... The Preserve Format option can preserve certain formats when the table is refreshed, but not others. For example cell borders and conditional formatting is lost no matter what. -- Peter Aitken Remove the crap from my email address before using. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Macro to launch web page | Excel Discussion (Misc queries) | |||
Macro launch - Button vs Manual launch , has different results. | Excel Programming | |||
Can you use an IF statement to launch a macro? | Excel Programming | |||
auto-launch a MACRO? | Excel Programming | |||
Launch Macro in Access via Macro running in Excel??? | Excel Programming |